Xlookup In Excel: Explained In 3 Minutes

Показать описание

In this video, I give a brief overview of the new XLOOKUP function in Excel, an alternative to VLOOKUP or INDEX MATCH.

Here are some of the major features of XLOOKUP that I share in the video:

1. Only 3 Required Arguments
2. Exact Match by Default
3. Separate Lookup & Return Ranges
4. Vertical OR Horizontal Lookup
5. Partial Match with Wildcards
6. Reverse Search Order
7. Cause of # VALUE! Error
8. Availability & Compatibility

The XLOOKUP function searches for the lookup value in a column/row and returns a value from an adjacent row/column where the match is found.

It has options for exact match, closest match, and partial match with wildcard characters. It can also search in reverse order.

Additional Resources:

Please leave a comment below with any questions or suggestions. Thank you! 🙂

#ExcelCampus #MsExcel
00:00 Introduction
00:50 XLOOKUP
01:58 Search Order

Рекомендации по теме

Комментарии

I've seen a lot of Excel tutorials and I think this one was the most helpful and concise. Your flow, use of colors, onscreen text.. idk what it is but I really like this format!

hhectorlector

Kudos, straight to the point without any unnecessary chit chats. Keep it up!! FYI, this has helped me to merge data and simplified my analysis for my company.

jarofclay

fantastic video, you explained this formula with great clarity and used a good pace. This is the best video I have come across for explaining XLOOKUP. Many thanks from England

aminamaradesa

Thank you! You sir, have saved me quite a bit of time of my newest excel project :D
*Edit*
You have explained exactly what I want to do within the span of 2 minutes (haven't finished yet) versus an insurmountable number of hours trying to red through material!

elijahful

Simple, short, accurate and very easy to understand. Great work!

gabrielcunha

thanks!!!! I got what i needed to crank a massive file 45 seconds into your video. You rock bro!

josephalaguna

Successfully used the technique after watching 0:34 seconds of the video. Very much appreciated!

BeanCounter

Super easy and helpful, think 1 min was sufficient. Thank you!

hokinizeu

Great video. Appreciate how quickly you get the key points of use across. Sub-5 minutes, perfect!

zanderpain

Thank you for mentioning the critically important O365 exclusivity caveat!

geoffplesa

Satisfying explanation. Didn't skip the ads. Least I can do.

kunaalthakur

You’ve done a fantastic job with your video. Thank you very much for offering a concise summary of an Excel function. This is generally exactly what I need when YouTubing Excel information.

wreilly