The global body for professional accountants

Apply now
Request info
myACCA
3
UNITS

Recorded webinar | ACCA

Excel workshop: mastering Lookup formulas in modern Excel

Boost your Excel skills with essential tools for data handling, automation, and analysis: available as single sessions or a full discounted course

Overview

Person in office

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.

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.

Alan Murray

Alan Murray is an Excel trainer, founder of Computergaga.com and author of the Advanced Excel Success and Advanced Excel Formulas books. He has been helping people in Excel for over 23 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. Alan’s Computergaga YouTube channel has over 650 videos and over 50 million views. He also runs the monthly London Excel Meetup Group, where people learn, network, and enjoy each other’s company.

The handout materials have been shared with you. Please keep them handy for practice during the session.

This session was recorded on 14th Nov 2025.

Pricing and booking information

Price

Price (excluding VAT) 105 GBP

Location

United Kingdom

Date & time

On demand

Enquiries

Email enquiries UKCL@accaglobal.com

Book on ACCA

Course provider

ACCA logo