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.