Introduction to XLOOKUP in Excel 365

Date/Time: Wednesday, 19th May 2021 - 10:00 am - 10:45 am

Location: Online

Available Spaces: 25

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.

[ultimatemember form_id="3621"]