This is a new function that warrants its own webinar. It can replace 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.
Level: Intermediate
Duration: 1.5 hours
Price: AU$25