This function replaces VLOOKUP and HLOOKUP. It can also replace the INDEX-MATCH combination.

NOTE: You need the subscription version of Excel to use XLOOKUP.
You will

• learn the basics of the XLOOKUP function

• discover how easy it is to handle #N/A errors

• see how to look from the bottom up

• use XLOOKUP to return a reference

• see how to use XLOOKUP with dynamic arrays

• learn how to return multiple columns

• discover how to do wildcard searches

• learn how to do two-way look ups

• discover how to do two-column lookups

• see how to use regex patterns to perform lookups

As always, you will discover a few other tips during the session.
Recorded: August 2026
Level: Intermediate
Duration: 70 min
Price: AU$25