How to do a 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.

🚩Let’s connect on social:

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

[mrhakz]

Just found you today and I'd admit this is the best excel channel on YouTube. Really appreciate your effort. SUBSCRIBED

[bayarahmed]

Hello leila,
I just wanted to say thank you!
You helped me a lot through my career ! I wish you all the best.

[excelisfun]

Thanks for the XLOOKUP (with the correct arguments) fun, Leila!!!

[wayneedmondson]

Hi Leila.. thanks for the left lookup with XLOOKUP. Of course, without XLOOKUP the go to favorite would be an INDEX and MATCH solution. Just for the fun of it, some don't know that you can get VLOOKUP to look left by tricking it with CHOOSE, as in: =VLOOKUP(A4, CHOOSE({1, 2}, Master!$C$4:$C$33, Master!$A$4:$A$33), 2, 0). Fun to slice and dice a problem using different solutions. Thanks for all your videos. I always learn something new at your channel :-)) Thumbs up!

[TCJACJ]

Thanks for the video. You are the best looking teacher ever.

[eqdklkd]

left or wright Leila is always in heart .thx queen

[aaaaaaaaa]

Thx for the video appreaciate all the hardwork

[queeniegonsalves]

Thanks a lot Ma'am for such an easy way to get the left hand side data

[mattschoular]

I say bring lookup to the masses. Thanks for sharing

[Betterifitsfree]

More useful excel majic from Leila. Thank you Thank you.

[kbalaji]

really..good.. its solves vlookup problem

[gintomino]

What's unique in your channel is that your videos are so easy to learn. Good pacing as well. You should also be teaching in schools.

[dennisd]

For those without XLOOKUP the easiest way is to use the DGET function; it can look to the left.

[enriquedominguez]

Thank you for the update Leila. Great Video.

[gmo]

Good vid. Thx. I would say, "locked" instead of "fixed" though. Fixed has the other meaning of corrected. That confuses me. I say locked when locking a range, but that is my personal preference.

[mohamedelhussein]

Valuable information and helpful, thanks

[Deependra]

Nice dress mam as well as nice video...

[deathfireart]

Great Video!!! can you make a tutorial on how to use the xlookup in a table with a defined name to look at the leftmost column of the table similar to vlookup? I want to use the xlookup to search for approximate values but my data are in a table (dynamic changing) where the look values are located on the leftmost column. Thank you in advance 🙂

[ashutoshdwivedi]

Good Knowledge in Excel And Accounting
Please make the video accounting bases

[leealex]

can be done also with hlookup and match functions in older version
=hlookup(column name containing the data to be found, aimed searching field, match(given lookup value, array containing the lookup value, match type), false)