Microsoft Excel: Lookup Functions

Wishlist Share

About Course

Find and match data across tables with XLOOKUP, VLOOKUP, INDEX/MATCH and related functions—and handle missing values.

Tutwoo is an independent learning provider. This course is not affiliated with or endorsed by any software company named. Product features and menus change over time—check the official help pages for the latest details.

What Will You Learn?

  • Use XLOOKUP for flexible lookups Use VLOOKUP and understand its limits Combine INDEX and MATCH Handle missing values and approximate matches

Course Content

Course Lessons

  • XLOOKUP
  • VLOOKUP
  • INDEX/MATCH and errors

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕