Introduction to XLOOKUP in Excel 365

Date/Time: Wednesday, 28th April 2021 - 11:00 am - 11:45 am

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.

[ultimatemember form_id="3621"]