IF and VLOOKUP Nested Function | VLOOKUP with a Drop-down
Microsoft Excel Tips and Tricks In this video I explore combining IF with VLOOKUP. 1) In the first scenario I[…]
Read moreMicrosoft Excel Tips and Tricks In this video I explore combining IF with VLOOKUP. 1) In the first scenario I[…]
Read moreMicrosoft Excel Tips and Tricks In this video I demonstrate how to perform a wildcard “contains” test in an IF[…]
Read moreMicrosoft Excel Tips and Tricks In this video I demonstrate how to perform partial match SUMIFS and COUNTIFS calculations using[…]
Read moreMicrosoft Excel Tips and Tricks Using List functions in Power Query to do Exact Lookup and Approximate Match Lookup is[…]
Read moreMicrosoft Excel Tips and Tricks PivotTable running totals just don’t make sense sometimes. In this video I’ll show you why[…]
Read more