Excel – Introduction to XLOOKUP

Date/Time: Wednesday, 4th January 2023 - 14:00 - 14:45
Location: Online
Available Spaces: 15
Contact Details: Paul Atwell: paul.atwell1@nhs.net


Demonstration of the XLOOKUP function, used in place of the functions VLOOKUP and HLOOKUP, both of which have their limitations.

A good to advanced working knowledge of Excel.
Ideally, previous use of the VLOOKUP function.

Course outline

  • Using XLOOKUP instead of
  • 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

The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.

You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.