The Ultimate XLOOKUP Tutorial (The Best Excel Formula)

Xlookup formula tutorial in Excel using 5 examples.

Learn how to use the XLOOKUP function in Excel with 5 examples from easy to hard. First, you'll learn how to use a simple XLOOKUP and replace a VLOOKUP. Then, you'll learn how to use the XLOOKUP with a wildcard for approximate matches. Third, you'll learn how to use the xlookup with multiple conditions to replace the index match. Fourth, we'll look at approximate matches using the match mode for matches that are smaller than a certain number. Finally, we'll look at getting multiple answers with the spill feature in XLOOKUP. Once we understand the xlookup, we'll look at some of the limitations of the formula, especially with summing values.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ XLOOKUP Example 1
1:57​ - XLOOKUP with Wildcard Chart
3:39​ - XLOOKUP with Multiple Conditions
6:08​ - Match Mode XLOOKUP
8:13​ - XLOOKUP with multiple answers
9:42 - XLOOKUP problems

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

[JenniferDuran-ck]

Excellent tutorial. Really appreciate you breaking it down and making it simple. Love the shortcuts

[GmanMilli]

4:55 Very informative! So the inner xlookup returns a column from a group of columns, while the outer xlookup returns a cell from a column (group of cells). 9:14 or return a row from a group of rows.

[AzeezulGani]

I would really watch your excel classes for the whole day!
You really make the formula so easy to understand and the places where it could be probably used.
Thank you so much!

[RogerKlauser]

You are the man Kenji. I've worked in accounting for 7 years and consider myself very proficient in excel, however you've taught me so much in the few short videos I've found. New subscriber!

[rahilhashmi]

You are a good Excel teacher. I understand you easily. Thanks

[charlieee]

Kenji is the real GOAT 😊😊❤❤. Thank you for all your videos man, ..

[kkvenbm]

I am a beginner, still receiving class. I enjoy watch your videos, very self explanatory

[premierleague]

I love how you clearly explain how to apply formulas love from Kenya

[corporate_guyfitness]

I used sumproduct for the last limitations part

[wattosworkshop]

Thanks for your clear, direct and informative instruction. I have subscribed.

[jennaolivieri]

Kenji thank you for your help, I am also wondering how to use the formula for a different output. For example, in your third example, if I wanted to know which employee had 7, 392 in sales in February how would I use the formula to populate the name Sergio Perez?

[High_Goblin_King]

Thanks for mentioning the shortcuts everytime you use them!

[XLLearner_Courses]

Yes, I agree. One of the functions I use daily

[amusaazeez]

We appreciate you, keep on good work
From Nigeria

[imanasri]

brilliant. thank you so much Kenji for the tutorial video! love from Malaysia

[Nah]

Always work in tables, never in ranges.

[hollywoodinkannada]

It is something good, but for the Value I do the Data Validation which saves typing time 😉

[pawan.space....]

really helpful to explain this by you kenji

[hanko]

I am in a bootcamp for data analytics and I found this video so helpful

[jlblpgk]

How to ignore blank cell reference in xlookup function? (Its returning blank cell value if cell reference and search criteria blank)