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.
Tag Archives: XLOOKUP
Getting Wild About XLOOKUP
Part Four - you can use wildcards!
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.
Excel XLOOKUP Actually Looks Down
Part Three - but things are looking up
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.
Excel XLOOKUP Flexibility
Part two
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.
New XLOOKUP Function in Excel
Part One
It’s finally here, well it is if you have the monthly update cycle of the subscription version of Excel.