Excel – Introduction to XLOOKUP

Date/Time: Monday, 28th June 2021 - 3:00 pm - 3:45 pm

Location: Online

Available Spaces: 15

Contact Details: Paul Atwell: paul.atwell1@nhs.net

Description

The XLOOKUP function (introduced to Excel in 2020) can be used in place of the functions VLOOKUP and HLOOKUP, both of which have their limitations.  This course is suited to those who have used the functions VLOOKUP and HLOOKUP previously.

Session contents:

  • Using XLOOKUP instead of VLOOKUP/HLOOKUP with IFERROR
  • Why using a Nested XLOOKUP could be useful
  • Limitations of VLOOKUP and HLOOKUP
  • Using XLOOKUP instead of INDEX and MATCH
  • Finding the nearest match using XLOOKUP

This session is 30 minutes in duration with an additional 15 minutes for a Q & A session which you are not obligated to remain for.


You need to be logged in in order to be able to register for this event.