Excel – Introduction to XLOOKUP

When

August 13, 2024
1:30 pm - 2:15 pm
5 spaces left

Where

Online

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.
PLEASE NOTE: This is the 11th course in a suggested series of the 14 Excel sessions available.

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.

Number of Spaces

You must log in or register to make a booking.