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 more
Tag: excel
Excel Wildcard IF – NOT WORKING! | If Cell Contains Text Then…
Microsoft Excel Tips and Tricks In this video I demonstrate how to perform a wildcard “contains” test in an IF[…]
Read more
SUMIFS & COUNTIFS Partial Match | Part of Cell Contains Text
Microsoft Excel Tips and Tricks In this video I demonstrate how to perform partial match SUMIFS and COUNTIFS calculations using[…]
Read more
VLOOKUP in Power Query Using List Functions
Microsoft Excel Tips and Tricks Using List functions in Power Query to do Exact Lookup and Approximate Match Lookup is[…]
Read more
Problems with PivotTable Running Totals and How to Fix Them
Microsoft Excel Tips and Tricks PivotTable running totals just don’t make sense sometimes. In this video I’ll show you why[…]
Read more