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.

*** Availability of XLOOKUP: XLOOKUP will only be available to Excel for Office 365. It will not be available for Excel 2016 or Excel 2019. Currently XLOOKUP is available for public testing in the Office INSIDER program. For more information on how to become an office insider check out this link:

⯆ Article & Workbook use is here:

Original XLOOKUP video:

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free


EXCEL RESOURCES I Recommend:

Get Office 365:
Microsoft Surface:

GEAR
Camera:
Screen recorder:
Microphone:
Lights:

More resources on my Amazon page:

Let’s connect on social:
Instagram:
Twitter:
LinkedIn:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

XelplusVis,Leila Gharani,Advanced Excel tricks,Excel online course,Excel tips and tricks,Excel for analysts,Microsoft Excel tutorials,Microsoft Excel,Excel for office 365,microsoft excel 365,Office 365,Vlookup left,vlookup to the left,Excel XLOOKUP,left lookup in excel,index match left,XLOOKUP to the left,excel return value from another column,vlookup out of order,excel lookup another sheet,