This one is all about Microsoft Excel’s game-changing new lookup function – XLOOKUP! If you’ve ever suffered the delights of lookup formulas using Excel functions like VLOOKUP, HLOOKUP, MATCH and INDEX, then you’re going to love this function.
Clair Taylor takes us through various, familiar lookup scenarios: vertical and horizontal lookups, exact matches, approximate matches, two-way lookups, multiple values and the rest…