Excel 2021 XLOOKUP Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: https://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:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://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.