Excel 2021 XLOOKUP Tutorial

Excel 2021 XLOOKUP Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3Cpc0Fc
Who it's for: All Excel users, especially those looking for the next best feature.
What it is: XLOOKUP is a powerful new lookup function in Excel, letting users search for and find items in a table faster than ever before.
What you'll learn: First, you'll learn about VLOOKUP and Index and Match, the precursors to XLOOKUP. We'll talk about what makes those functions fantastic and what makes them lacking in certain areas. Then, we'll explain why XLOOKUP is a huge improvement and how to properly use it to level up your Excel performance.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
VLOOKUP Refresher 3:59
XLOOKUP Basics 11:42
INDEX and MATCH 17:03
XLOOKUP - Approx Match Results 20:36
XLOOKUP - Returning Multiple Values 23:39
XLOOKUP - Two Way Search 26:14
Conclusion 29:12
#excel #exceltutorial #exceltips #xlookup
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@zulfiqaarbaksh208]

This is, hands down, the best explanation for XLOOKUP on KZbin. So clearly explained and demonstrated. Thank you!

[@LearnitTraining]

Wow, thanks!

[@spiral_thoughts]

Hey, thank you so much for presenting this cool XLOOKUP function in such an easy-to-understand way ! Now, with the help of this one function I can save so much of my time at work !!! 😇❤

[@LearnitTraining]

You are very welcome!

[@elsiebernard3919]

Can you demonstrate XLOOKUP to compare two column in different worksheet

[@LearnitTraining]

Hi Elsie! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@yerbolabzhamiyev3268]

@@LearnitTraining, the link doesn't work. Can you check it, please?

[@ly1x]

having tech issues. every time I tried logging in, it takes me back to the "create an account" page. any clues please?

[@LearnitTraining]

Hi P E! There shouldn't be anything to login for. If you are trying to open Office 365 your free trial may have ended.

[@AljIsHere128]

It would have been nice to have more of an understanding of xmatch. You kinda breezed through it without clarity.

[@LearnitTraining]

Noted! We will expand upon it in an updated video!