The new XLOOKUP function has the ability to spill when you select multiple columns to extract. Even when you do, it doesn’t always spill across.
Being able to use wildcard characters like * and ? in searches is something we are used to having. Now XLOOKUP allows you to do those types of searches in Excel.
Did you know that VLOOKUP actually looks down? That’s right, it finds the first entry from the top down. The default XLOOKUP also looks down, but can start from the bottom and look up.
The INDEX and OFFSET functions can return a reference to a cell, something VLOOKUP can’t do. XLOOKUP can return a cell reference, let’s see one way to use it.
It’s finally here, well it is if you have the monthly update cycle of the subscription version of Excel.