Главная
Study mode:
on
1
Start
2
VLOOKUP Refresher
3
XLOOKUP Basics
4
INDEX and MATCH
5
XLOOKUP - Approx Match Results
6
XLOOKUP - Returning Multiple Values
7
XLOOKUP - Two Way Search
8
Conclusion
Description:
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.

Excel 2021 XLOOKUP Tutorial

Learnit Training
Add to list
0:00 / 0:00