This course provides a demonstration of the XLOOKUP function which can be used in place of the functions VLOOKUP and HLOOKUP, both of which have their limitations. The topics are:
- 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
Login
Accessing this course requires a login. Please enter your credentials below!