How to do a Left Lookup in Excel with XLOOKUP (Made Easy)
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...
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...
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-...
Original XLOOKUP video: • Discover What XLOOKUP Can Do For YOU ...
★ My Online Excel Courses ► https://www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ 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: / lgharani
LinkedIn: / 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
Watch video How to do a Left Lookup in Excel with XLOOKUP (Made Easy) online without registration, duration hours minute second in high quality. This video was added by user Leila Gharani 21 November 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 95,54 once and liked it 2.3 thousand people.