Date: | 29/08/2023 |
---|---|
Time: | 1:00 PM AEST |
Event: | XLOOKUP Function (1.5hrs) |
Topic: | XLOOKUP Function |
Public: | Public |
Registration: | Click here to register. |
Webinar – XLOOKUP Function (1.5 hours)
Price: $25 incl GST
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.