TWO COLUMN Lookup in Excel with the XLOOKUP Function

How to do a two column lookup in Excel using the XLOOKUP function.

In this example, we need a two column match with XLOOKUP to return a price that is dependent upon the room booked and if lunch is included.

This two column lookup is often referred to as a two criteria lookup and the XLOOKUP function makes this easy.

Create multiple column lookup formulas with the same technique.

Case sensitive XLOOKUP formula

More great XLOOKUP function examples

Learn more advanced Excel tricks

Connect with me!

#excel #excelformulas #excel365

[ericmoz]

Im so happy I found this video thank you. I have been doing all sort of workaround and making fake reference keys just to have more than one "look up value"
lord this is so simple! thank you I'll remember this and use this forever.

[sheppardsshep]

Simply explained and so powerful - thank you

[mymatemartin]

Excellent. Great example of new generation capabilities

[gozob]

I'm so happy, you saved my life, oh my goodness. That '&' was what I was missing. I can't believe it was so simple

[nadermounir]

Thank you Alan for this nice video 📹 👍

[srikanthranky]

Choke slamming SumIfs function. Nice video

[queenslyaustin]

Thank you so much!!! I spent hours and hours looking for a solution to this and your video finally gave me respite. I tried index match match, sumifs, vlookup match, all to no avail. Thanks again!

[roderickmose]

Giving the new kids (DAs) on the block some old school wisdom!

[charlessmith]

what if i dont want to combine the two cols but rather look in both cols to find either value?

[chahineatallah]

Very easy compared to vlookup, in vlookup I used to have like helper column to do same thing