This is a new function that warrants its own webinar. It can replace VLOOKUP and HLOOKUP. It can also replace the INDEX-MATCH combination.

Included attendance at live webinar Tuesday July 30 2024.

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.

Level: Intermediate
Duration: 1.5 hours
Price: AU$25