Excel – Introduction to XLOOKUP

Date/Time: Monday, 21st June 2021 - 2:00 pm - 2:45 pm

Location: Online

Available Spaces: 20

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

Description

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.