XLOOKUP in Excel Tutorial

In this step-by-step beginner's tutorial, learn how to use the XLOOKUP function in Microsoft Excel. With Excel XLOOKUP formula, you can look up values on the same worksheet or between multiple worksheets. For example, let's say I have a cookie name, chocolate chip, my favorite, and I want to know the price. I have another table with the prices. I can look up the cookie name and get the price back. We'll look at how this function works in the simplest form and then we'll look at more advanced capabilities. XLOOKUP is currently available to Microsoft 365 subscribes. If you don't have Microsoft 365, you can use VLOOKUP or HLOOKUP.

👋 Additional resources

⌚ Timestamps
0:00 Introduction
1:13 Basic example of XLOOKUP
4:20 Show text when value is not found
5:11 Horizontal lists
5:45 Across worksheets
6:32 Return multiple items
7:29 Nest within other functions
8:58 Use multiple criteria
10:10 Match modes
11:59 Search modes
13:02 Nested XLOOKUP for grid view lookup
15:59 Wrap up

📃 Watch related playlists

🚩 Connect with me on social

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert

[hederamom]

Kevin is such an amazing teacher. He intuitively expects the exact question that pops in my mind as he instructs, and always answers simply, thoroughly and pleasantly.
One request - with all the 60+ fantastic videos available, I wish they could be listed in order of basic to difficult, so I know what to watch next. I know it's subjective for some, looking for a specific tasks.

[tedmoy]

Love this channel. Kevin makes it so easy to comprehend and absorb the material. I've tried other channels and his explanations/training is easy to understand.

[emilykasuya]

Remember all these days needing to look at his videos quickly to understand something quickly on excel. Now I'm probably going to need to watch videos from Kevin most of the time and wow didn't realise how enjoyable these videos really are. Got a knack for making boring things look interesting, and that is a true talent...

[baltic]

Thank you Kevin for the nested Xlookup example! Even though we may alternatively use INDEX and MATCH functions to get the same result, nested Xlookup is much easier to use!

[KristinPelletierMOS]

I am a Microsoft Instructor and own my own Post Secondary school - Excel has always been hard to explain these features to beginners who fear Excel because no one is able to teach it so newbies can understand. You broke that mold Kev! Thanks for giving me simplicity so I can give that to my students!!

[loloysan]

As usual, always easy to understand, digest, remember and yet really effective tutorial. Nice one Kevs, appreciate this.

[Kaz-nfns]

vlookup and xlookup are very confusing for me but your tutorials are super awesome! I love how you repeat the steps and those repeats greatly improve my understanding of these functions. The different levels of examples are interesting. Thanks, Kevin for all your outstanding and consistent tutorials. I just search for your name whenever I require any tutorials 😊

[peekaboo]

I'm grateful for your content, Kev! Learning this in school and your explanation is way better! Thank you for also using cookies as an example -- I'm able to understand 100%

[allpoems]

Your "timestamp" is an excellent idea. Thank You 🙂

[jordankopal]

Hey Kevin, I have enjoyed your videos, and you help me a lot in my post secondary studies with excel stuff, much appreciated.

[ochuutv]

Kelvin you such a sweet man... this short video, hv made me understand xlookup with ease after years of confusion...
You're a great teacher..😊😊❤

[Ben]

Thank you Kevin! I'm learning so much about "Lookup" functions. People handle so many data and this is a great help for those who work a lot with Excel sheet.

[SavageGothamChess]

Hopefully in the future there will be something called Diagonal Look Up. That would be hysteric?
Loved the video and thanks for a chocolate chip cookie!! 😋🍪

[emilythechef]

Thank you Kevin, this was just what I needed! I have had this feature available to me for over a year, but I was just so used to VLookup, and accommodating my data to facilitate it working, but this is really a game changer and will make for less complicated spreadsheets.

[prof.code-dude]

Nothing better than watching Kevin's video and eating a chocolate cookie 🍪

[AvanishKesharwani]

Unbelievable explanation Kevin, I had watched your previous video about VLOOKUP and HLOOKUP but I was not knowing about this. Thanks again :-)

[naveen]

You know what i always try to watch videos even i know that featur but i willalways be amazed by hidden or complete futures until u have covered. Today its returnin multiple lists and without helper column combining search array and grideview.

[Tpazmachine]

Absolutely love this level of explanation and detail and ease of use!

[piyushmohapatra]

Hey Kevin you always upload the videos which I need the most at just the right time 😀

[keishrich]

Learned about the multiple values returned and nested XLOOKUP. Thx 😊