Excel XLOOKUP

This course is included (as well as over 200 others) in every subscription!
Description
Materials

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.

Excel XLOOKUP

Sign up to view this video Video Description
  • Introduction
  • Introduction to VLOOKUP
  • VLOOKUP Limitations
  • Introduction to Index and Match
  • Introduction to XLOOKUP
  • XLOOKUP - Approximate Match
  • XLOOKUP - Multiple Values Returned
  • XLOOKUP - Two Way Search
  • Conclusion
 
No Practice Files

Related Courses

Why Choose Anytime

Over 450,000 students since 1996

Over 20 years teaching software to industry leaders

100% 7-day money back guarantee

Feel secure: Ask a teacher if you have questions

Classroom Training available in Downtown San Francisco - 33 New Montgomery, SF CA 94102