Premium Only Content

Left Lookup in Excel with XLOOKUP (Made Easy)
21 November 2019 Excel for Office 365 & Dynamic Arrays
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 is available in Excel for Office 365. 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://courses.xelplus.com/p/excel-dynamic-array-formulas
⯆ Article & Workbook use is here: https://www.xelplus.com/excel-lookup-to-the-left-with-xlookup/
Original XLOOKUP video: https://rumble.com/v2uqp14
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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 #Excel #LeilaGharani
-
1:30:48
Redacted News
2 hours agoBREAKING! TRUMP AND PUTIN NEARING PEACE BUT EUROPEAN WARMONGERS TRYING TO STOP IT | REDACTED
58.3K49 -
52:40
Candace Show Podcast
2 hours agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
45.7K32 -
LIVE
Revenge of the Cis
3 hours agoEpisode 1449: Boo This
2,001 watching -
1:20:31
Awaken With JP
4 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
54.4K27 -
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
65.3K24 -
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
77 watching -
LIVE
John Crump Live
5 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
237 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
468 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
18.8K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $1.26 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1