XLOOKUP and the Last Entry
One major advantage XLOOKUP has over VLOOKUP is that it can search from right to left. That makes it useful for finance models where you need to identify the last month with a payment, balance, or forecast value.
(more…)Extracting Dates with XLOOKUP
One issue you may find with dates when extracting from a look up table is that an empty date field generates a zero. You can avoid that with a simple formula adjustment.
(more…)Two Column Lookup in Excel – Part 1
It is common to perform a lookup based on one column. Performing a lookup based on two columns is more unusual. This is a formula technique you can use to perform a two-column look up.
(more…)XLOOKUP Doesn’t Always Spill
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.
(more…)Getting Wild About XLOOKUP
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. (more…)
Excel XLOOKUP Actually Looks Down
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. (more…)
Excel XLOOKUP Flexibility
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.
(more…)New XLOOKUP Function in Excel
It’s finally here, well it is if you have the monthly update cycle of the subscription version of Excel.
(more…)