Excel – Introduction to XLOOKUP

Date/Time: Wednesday, 28th September 2022 - 14:00 - 14:45
Location: Online
Available Spaces: 18
Contact Details: Paul Atwell: paul.atwell1@nhs.net

Description

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

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

Course outline

  • Using XLOOKUP instead of
    – VLOOKUP
    – HLOOKUP
  • 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.