⌘K

A common Excel Lookup question is: How to return a value left of the lookup range in Excel? It’s not easy if you use VLOOKUP. You either need to use a workaround or INDEX and MATCH.
With the Excel’s XLOOKUP function we can use one single formula to do a left lookup in Excel. It’s super easy because XLOOKUP takes the best of VLOOKUP and INDEX & MATCH formulas. We have a separate independent lookup range and a separate return range.

#excel #developer

youtube.com

Left Lookup in Excel with XLOOKUP (Made Easy)

A common Excel Lookup question is: How to return a value left of the lookup range in Excel? It's not easy if you use VLOOKUP. You either need to use a workaround or INDEX and MATCH. With the Excel's XLOOKUP function we can use one single formula to do a left lookup in Excel. It's super easy because XLOOKUP takes the best of VLOOKUP and INDEX & MATCH formulas. We have a separate independent lookup range and a separate return range.

1.60 GEEK