I don't use VLOOKUP anymore. I use this instead....

VLOOKUP is the most used Excel function out there. But here is a secret. I no longer use it!!!

That is right. I broke up with VLOOKUP.
I use XLOOKUP now. It is a new function in Excel 365.

So in this video, let me introduce you to my new crush 😍 - The XLOOKUP.

In this video, learn all about:
👉 What is XLOOKUP and how it's better than VLOOKUP
👉 Using XLOOKUP in business situations
👉 Errors & XLOOKUP (if not found option)
👉 XLOOKUP with tabular data
👉 Wildcard (pattern) matching with XLOOKUP
👉 Returning multiple values with XLOOKUP
👉 XLOOKUP vs. HLOOKUP

Video topics ⏱👇
==============
0:00 - VLOOKUP & XLOOKUP - Quick examples
2:13 - Difference between VLOOKUP & XLOOKUP
2:30 - Using XLOOKUP instead of INDEX + MATCH
3:32 - Dealing with Errors (#N/A) using XLOOKUP
4:57 - XLOOKUP with Tabular Data (tables)
5:40 - Wild card (pattern matching) with XLOOKUP
7:40 - Returning multiple values with XLOOKUP
9:10 - XLOOKUP works horizontally too!!!

Example file (with many many XLOOKUPs) 🟩👉
=======================================

Watch next 👨‍💻👩‍💻👉
================

#excel #xlookup

~

What does Charles Xavier use to find mutants?
XLOOKUP of course 🤣

[Excelambda]

Great video!!
Still VLOOKUP is versatile when it comes to column indexes.
For example, in "XLOOKUP (table)" spreadsheet, if we set in the range C5:F5 : Name, Start date, Salary, Department, to extract the values corresponding to those columns we can use in C7:
=VLOOKUP(C6, staff, XMATCH(C5:F5, staff[#Headers]))
or
=VLOOKUP(C6, staff, {2, 6, 5, 4})

[chrism]

I agree Chandoo. Once XLOOKUP came out, I haven't used VLOOKUP since. Great video

[KhiaraHarsh]

I find your step by step instructions very useful and relatable to a practical scenario. Keep up the good work!

[TannerDavies]

One of the best tutorials I've seen. Love your excel and PBI videos!

[pctLowBattery]

Cool 😎
I started at a new company that uses office 365. Old company still used 2010 old excel. Lots to learn with new excel features.

[canirmalchoudhary]

Even I hate VLOOKUP and this video is best ever video as XLOOKUP tutorial
Awesome 👌

[udaimadduri]

This is fantastic! I have been dreaming for these simple useful features for several decades. Finally, my dream came true. Thank you so much!

[dkjangir]

great sir I believe you are the first website i used to learn excel at all.& I am very happy to see again chandoo excel expert.

[richasingh-zupz]

wow you teach in such a simple manner !!!

[Rood]

3:47 into the video, and I stopped playback to subscribe. Great info that’s easy to follow, with practical examples.

[rkmsafi]

Master class.. Way back I learn from you in excel webpage.. Now you are on youtube.. We are expecting a fire works..🔥🔥

[utubeAgape]

Same here! Ever since Xlookup came on the scene, I stopped using VLookup AND index match - Xlookup is much more efficient!

[Magahasaracom]

Wow until I watched this video Xlookup has been complex for me to understand. You explained everything so simply and thank you

[wayneedmondson]

Awesome Chandoo! Thanks for the great lookup examples both old and new. Thumbs up!!

[abbottkatz]

You can also return multiple resuts in VLOOKUP with column index numbers surrounded by squiggly brackets as array constants.

[johnkempes]

Thank you Uncle, you are very Humble, , ,

[Moglikaur]

Great video by great Chandoo .. thank you for this..

[rameshbhatt]

Thanks Chandoo, this is awesome. I look after so many things in YouTube but never really subscribed anything. After watching your video today, I instantly subscribed and clicked on like as well. This is really helpful and presented very nicely. Appreciate it, god bless you!

[neXianXaviaX]

Chandoo help! I have a lot of things to lookup, I have multiple tables and I have to add my lookup results together! Not only that but there's many totals I want to calculate and put into a new table!

Very useful, I've watched a few of your videos and I'm a fan so I clicked the subscribe button for more excel tips :p

[harishpoalampalli]

This is Incredible !! simply the superb replacement of INDEX MATCH + VLOOKUP very powerful!! thanks a chandoo !! This is helping me a lot !! Great Explanation with sample workbook !! the uniqueness in you is providing the entire workbook for practice which helps a lot by watching the video and on fly implementing them !! Great Keep them coming chandoo!!