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.