This is a new function that warrants its own webinar. It 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

• see how to select from multiple tables

• learn how to do two-way look ups

• discover how to do two-column lookups

• return multiple rows with the FILTER function

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