Excel Lookup Formulas Made Simple: Think in Patterns

Master XLOOKUP, INDEX + MATCH, and FILTER with easy-to-follow pattern-based exercises

Created byLee Nuttall

Last updated 12/2025

English

What you'll learn

Choose the correct Excel lookup formula by understanding lookup patterns instead of memorizing syntax
Use XLOOKUP confidently to return accurate single results in modern Excel
Apply INDEX and MATCH together when XLOOKUP is not available or flexible layouts are needed
Return multiple results and build multi-criteria lookups using FILTER and logical conditions

Course content

1 section • 12 lectures • 51m total length

Welcome & How This Course Works1:12
Get familiar with the course goals, navigation, and how to use lectures and practice files effectively.
Why Lookup Formulas Feel Confusing1:14
Identify common pitfalls with lookup formulas and understand why memorization leads to errors.
The Lookup Decision Tree1:02
Learn a simple decision tree to choose the right lookup formula based on your data and task.
Pattern #1: XLOOKUP — The Modern Default1:22
Master XLOOKUP syntax, usage patterns, and when it’s the most efficient choice in modern Excel.
XLOOKUP in Action: Step-by-Step Examples17:52
Apply the XLOOKUP pattern to retrieve values accurately using real Excel examples and understand how each argument fits the lookup decision process. Download the Excel file and work through the exercises while watching the video.
Pattern #2: INDEX + MATCH — When XLOOKUP Isn’t Available1:25
Apply INDEX + MATCH as a reliable alternative and understand its pattern-based logic.
INDEX + MATCH in Action: Building Flexible Lookups18:00
Combine INDEX and MATCH to create flexible lookup formulas and understand how position-based logic replaces modern lookup functions. Download the Excel file and work through the exercises while watching the video.
Pattern #3: FILTER — Multiple Results Made Easy1:26
Use the FILTER function to extract dynamic results and simplify multi-row lookups.
FILTER in Action: Returning Multiple Results4:07
Use the FILTER pattern to return multiple matching results dynamically and understand how inclusion logic drives the output. Download the Excel file and work through the exercises while watching the video.
Pattern #4: Multiple Criteria Lookups1:39
Combine lookup formulas to handle multiple criteria efficiently without errors.
Common Lookup Mistakes — Pain Relief1:11
Recognize frequent lookup formula mistakes and learn strategies to avoid them.
How to Practice (Transition to File)1:18
Apply learned patterns using the practice workbook to reinforce skills and improve retention.

Requirements

Microsoft Excel 2019, Excel 2021, or Microsoft 365 installed on Windows or Mac
Basic familiarity with Excel, including cell references and simple formulas like IF or SUM
Ability to download and open the provided Excel practice workbook
No advanced Excel knowledge required — this course focuses on thinking patterns, not memorization
A mindset of improving problem-solving rather than copying formulas

Description

This course contains the use of artificial intelligence.

Stop guessing which Excel lookup formula to use.

Most people don’t struggle with Excel because formulas are hard — they struggle because they don’t understand the patterns behind the formulas. They memorize syntax instead of learning how to think through lookup problems.

In Excel Lookup Formulas Made Simple: Think in Patterns, you’ll learn how to master XLOOKUP, INDEX + MATCH, and FILTER by understanding when to use each tool — not just how to type them.

This course focuses on how Excel thinks.

Instead of throwing formulas at problems, you will learn to ask three simple questions:

What do I have?
Where am I looking?
What do I want back?

Those three questions form the backbone of every powerful lookup solution in Excel.

Every concept is taught using real-world examples and supported by downloadable practice files so you can follow along and build confidence as you go.

By the end of this course, you will be able to:

Build reliable lookup formulas that don’t break when data changes
Handle multi-criteria lookups cleanly
Replace fragile nested formulas with simple, readable logic
Use modern Excel dynamic array techniques to automate repetitive tasks

This is not a theory course — it is a practical pattern-based system you can reuse in any spreadsheet.

Who this course is for:

Excel users who feel stuck choosing between VLOOKUP, XLOOKUP, and FILTER
Office professionals who want to stop using fragile nested formulas
Students or analysts who want to understand lookup logic, not memorize syntax
Anyone who already knows basic Excel but wants clearer, more reliable formulas