Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2021 XLOOKUP Tutorial

Learnit Training via YouTube

Overview

Discover the power of XLOOKUP, Excel's latest lookup function, in this comprehensive 29-minute tutorial. Learn how XLOOKUP improves upon its predecessors VLOOKUP and INDEX/MATCH, enabling faster and more efficient table searches. Begin with a refresher on VLOOKUP, then explore XLOOKUP basics, approximate match results, returning multiple values, and performing two-way searches. Ideal for all Excel users seeking to enhance their spreadsheet skills, this tutorial provides practical examples and explanations to help you leverage XLOOKUP's capabilities and boost your Excel performance.

Syllabus

Start
VLOOKUP Refresher
XLOOKUP Basics
INDEX and MATCH
XLOOKUP - Approx Match Results
XLOOKUP - Returning Multiple Values
XLOOKUP - Two Way Search
Conclusion

Taught by

Learnit Training

Reviews

Start your review of Excel 2021 XLOOKUP Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.