Lookup formulas are at the heart of many Excel solutions — from matching values and pulling data across sheets to building dynamic reports and audit checks. But with the arrival of powerful new functions like XLOOKUP, FILTER, and dynamic arrays, many users are still relying on outdated or inefficient techniques.
In this session, we’ll demystify the world of lookup formulas and show you how to make smarter and more flexible use of Excel’s modern toolkit. Whether you're consolidating lists, cross-checking data, or building dynamic reports, these lookup strategies will take your spreadsheet skills to the next level.
This is session 3 of 3, you can purchase individual sessions or all 3 as a bundle for a discounted rate.
Key features
- From Legacy to Modern - A clear comparison of VLOOKUP, INDEX/MATCH, and XLOOKUP, with real-world use cases.
- Solving Complex Lookup Scenarios - Unlock techniques for multi-criteria retrieval using FILTER, XLOOKUP, array logic, and dynamic ranges.
- Smarter, More Flexible Lookups - Use XMATCH, CHOOSECOLS, HSTACK, GROUPBY, TAKE and more to build responsive, multi-dimensional lookup solutions.
By the end of the session, you’ll be able to utilise clean, modern formula solutions— and feel confident tackling lookup challenges of any kind in Excel.