Excel: Introduction to XLOOKUP

This course provides a demonstration of the XLOOKUP function which can be used in place of the functions VLOOKUP and HLOOKUP, both of which have their limitations. The topics are:

  • Using XLOOKUP instead of
    – VLOOKUP
    – HLOOKUP
  • Creating a two-way lookup with XLOOKUP
  • Overcoming limitations of VLOOKUP
  • Returning multiple results with a single XLOOKUP
  • Using XLOOKUP to find the nearest match
Not Enrolled
This course is currently closed

Course Includes

  • 7 Lessons