VLOOKUP vs XLOOKUP with Multiple Cell Criteria

This video looks at three ways to perform a lookup using multiple cell criteria. The methods are:

XLOOKUP (Office 365 or Excel Online)
VLOOKUP with helper column in lookup table
VLOOKUP with CHOOSE array formula.
------------------------

[hamzariazuddin]

Brilliant video and so easily explained. Thank you so much. This has saved me at least 15 minutes everyday trying to find values with multiple criteria.

[PavelVokral]

Thank You so much for explaining multiple cell criteria xlookup in 2, 5 minutes!!! Superb!

[christopherdesantis]

I was burning my neurons to do an xlookup with two criteria and was a matter of having the "&" connecting the two criteria, thank you so much.

[BBBBBBBBBB]

Great video, why have I never heard of XLookup before, what a great function

[mauveman]

Thank you so for much for making this video. I'd been looking everywhere for an explanation on how to do this. This video has solved my issue perfectly. Thanks again!

[clickbisi]

Ampersand to the rescue once again, didn’t know you could just do that. Thank you!

[franaryan]

After watching too many videos, only you were able to solve my problem...Like and Subscribed...Thank u

[irfanmohamed]

Im getting #VALUE error. Pls give me solution

[kilabirka]

Thank you for your help. I had done the formula and I kept getting the wrong answer.
Still, I watched your video and learned I had to use Ctrl+Shift+Enter for older Excel versions. Thanks.

[charmh]

Thank you so much for this well put together video. I looked through 5 videos before finding your video. It was straight, to the point and just what I needed. THANK YOU!

[ashishsinghi]

Many many thanks you have just solve my prob within very helpful video

[peter-mv]

Hey, you saved my afternoon free time. Thank you! Im Very happy now!

[nicksacco]

Thank you so much! I was trying to find a value in a table with multiple values. At first, I was using "Countif, " but this was much better.

[shwetagokulashtami]

I was banging my head since long for this...thank you so much for this video. It saved my 2 hrs time..

[riddhikedia]

Thanks a lot for this formula. It helped me a lot 😊

[bayders]

No words Can make you know how i thank you💛 You saved me

[analizsentez]

Thank you very much for clear and simple explanation ...

[danielserventi]

Excellent, thank you very much. Could you please provide the same example but with multiple columns to lookup in the table array (I.E., say there were additional budget columns from a different fiscal years)

[marybellandry]

Thank you! Works great on excel data formatted as tables.

[shivamsonkar]

Hey...this multi criteria isn't working with Ms office 2021 in my system.. However its working absolutely fine on Excel web.. any idea what's wrong? I downloaded new excel functions as well and added in add ins, still getting and#NA error