Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

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.

⬇️ Grab the workbook here: https://pages.xelplus.com/left-lookup-file

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 is available in Excel for Office 365 and 2021. It will not be available for Excel 2016 or Excel 2019. If you'd like to learn more about the new dynamic array functions like FILTER, UNIQUE & SORT check out the complete course: https://www.xelplus.com/course/excel-dynamic-array-365-formulas/

Original XLOOKUP video: https://youtu.be/xnLvEhXWSas

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

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!

#excel