Available Spaces: 18
Contact Details: Paul Atwell: firstname.lastname@example.org
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.
- 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.