XLOOKUP Excel Tutorial

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

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.

Exercise File: https://bit.ly/2Pxt3Lq

For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com

Enroll in our live, instructor-led Excel classes:
https://bit.ly/3GJWoeV

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

Exercise File: https://bit.ly/2Pxt3Lq

Start 0:00
Introduction 0:03
Introduction to VLOOKUP 2:31
VLOOKUP Limitations 10:29
Introduction to Index and Match 14:13
Introduction to XLOOKUP 23:04
XLOOKUP - Approximate Match 28:44
XLOOKUP - Multiple Values Returned 31:14
XLOOKUP - Two Way Search 33:32
Conclusion 37:47

#Xlookup #Excel

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.