Event Description

XLOOKUP has become Excel’s premier lookup function, replacing many of the limitations of VLOOKUP and HLOOKUP while introducing capabilities that were previously difficult or impossible to achieve. In this practical session, CPA and author of Microsoft 365 Excel for Dummies David Ringstrom demonstrates how to use XLOOKUP confidently to retrieve information, solve common lookup challenges, and build more reliable spreadsheets.

You’ll learn how to choose the appropriate match mode, replace older lookup functions, look up values in any direction, perform approximate and multi-criteria lookups, and troubleshoot common errors. Throughout the session, David explains not only how each technique works, but also when it provides the greatest advantage in real-world accounting and business scenarios.

Topics covered:
• Understanding XLOOKUP’s match modes and replacing older lookup functions. 
• Looking up values to the left, horizontally, and by approximate or partial matches. 
• Performing multi-criteria lookups and handling common lookup errors. 
• Using XLOOKUP in Excel Tables and returning multiple values with a single formula. 
• Choosing modern lookup techniques that simplify spreadsheet design and maintenance. 

Objectives

• Identify the advantages of XLOOKUP over older Excel lookup functions. 
• Apply different XLOOKUP match modes to solve common lookup scenarios. 
• Build lookup formulas that return one or more related values. 
• Troubleshoot and refine XLOOKUP formulas for more reliable results.