Webinar – XLOOKUP Function (1hr 30min)

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. Excel 2021 also has 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.

Date: 30/07/2024
Time: 1:00 PM AEST
Event: XLOOKUP Function (1hr 30min)
Topic: XLOOKUP Function
Public: Public
Registration: Click here to register.