Introduction to Excel Lookup Functions

Name: Introduction to Excel Lookup Functions
Rating: 4.5 (171 reviews)

Excel Basic Formulas and Lookup Functions with Xlookup Vlookup Index Match Index Double Match and Vlookup

Created byAliyu Nasir Musa

Last updated 8/2026

English

English [Auto],

What you'll learn

Understand and apply lookup functions in Excel.
Perform efficient data retrieval.
Troubleshoot common issues with lookup functions.
Integrate lookup functions in real-world scenarios

Course content

10 sections • 33 lectures • 1h 33m total length

SUM TOTAL, AVERAGE, MIN and MAX3:15
Introduction to these formulas, their functions and how to use them
COUNT and COUNTA3:07
Explore how count and counta in Excel reveal data structure: count numeric cells while counta counts all non-blank cells, including text and errors, with practical row-and-column examples.
Logic Functions (IF, AND OR and NOT)3:54
Apply if, and, or, and not logic functions in Excel to make decisions based on conditions like score, attendance, and payment to determine pass or fail and qualifications.
Error Handling (IFERROR & IFNA)3:26

Introduction1:55
Explore core Excel lookup functions—lookup, vlookup, index, match, index match, double match, and xlookup—with practical examples to boost data retrieval and accuracy.
What you need to know before we start0:50
Open the Excel app and review rows, columns, and typed data to prepare for using Excel lookup functions. Learn how these tools help you find and organize information fast.
A Quick Message1:22

HLOOKUP3:33
Learn how to use HLOOKUP to search for and retrieve data organized horizontally. Understand syntax, parameters, and practical tips for error handling and optimization.
IF_ERROR Statement in HLOOKUP2:45
VLOOKUP Introduction and exercise3:15
Get introduced to VLOOKUP
VLOOKUP Match2:39
Learn to enhance vlookup with the match function and data validation to dynamically select headers, enabling exact-match lookups and a responsive mini table of chosen columns.
Search bar using VLOOKUP2:25
Creating a search bar using VLOOKUP
Homework0:13
Using what you have learnt so far. add an If_Error statement into each column of your VLOOKUP search bar with a message of your choice.

Exact and Approximate Matches4:00
Exercise 10:27
Apply vlookup and iferror to create a discounted price column and automatically adjust sales revenue in the sales and inventory table.
Exercise 1 Solution4:18
Exercise 20:23
Use excel lookup techniques to correct sales revenue values after implementing unit-based discounts, and then update the sales and restocking table accordingly.
Exercise 2 Solution4:29
Master two Excel lookup methods to compute sales revenue: a single vlookup with product and inventory tables and exact match, then a two-vlookup formula approach with absolute references.

Introduction to Index Match4:01
Understand the fundamentals of the INDEX and MATCH functions, their individual roles, and how they work together to create a powerful alternative to traditional lookup methods.
Creating a search bar using Index Match4:30
Learn to build an interactive search bar using INDEX MATCH. This hands-on lecture demonstrates how to dynamically retrieve data based on user input, enhancing spreadsheet interactivity.
Index Double Match4:44
Advance your skills by performing two-dimensional lookups with INDEX. Master techniques to extract data using both row and column criteria for high-precision data retrieval.

Introduction to XLOOKUP3:56
Gain expertise in the XLOOKUP function, a powerful and versatile tool for data retrieval. Explore its advanced features, including error handling, multi-condition lookups, and the ability to perform reverse lookups.
Introduction to XMATCH1:46
Understand the fundamentals of the XMATCH function, and how it differs from the MATCH function.
Index XMATCH2:57
Understand the fundamentals of the INDEX and XMATCH functions.
Task: Counting Repeated Transactions Using XLOOKUP or XMATCH0:38

Requirements

Other than a basic familiarity with Excel, here are no strict prerequisites for taking this course, as it is designed to be accessible to beginners and experienced Excel users alike.

Description

Master the art of data retrieval and analysis in Excel with this comprehensive course on lookup functions. Designed for beginners and intermediate users, the course offers hands-on experience with essential tools like HLOOKUP, INDEX MATCH, and XLOOKUP. By the end of this course, you’ll confidently manage complex datasets and perform advanced lookups with ease.

Module 1: Introduction to Lookup Functions
Begin with the basics, exploring what lookup functions are, their purpose, and how they simplify data management. This module sets the foundation by showcasing real-world scenarios where lookup functions play a critical role.

Module 2: HLOOKUP
Learn how to retrieve data from horizontally arranged tables using the HLOOKUP function. Master its syntax, parameters, and troubleshooting techniques to handle errors effectively.

Module 3: INDEX MATCH
Discover the power of combining INDEX and MATCH for flexible, dynamic data lookups. This module covers their individual functions, how they work together, and tips to bypass VLOOKUP’s limitations.

Module 4: INDEX Double Match
Delve deeper into advanced lookups with INDEX. Learn how to use both row and column criteria to extract data with precision, unlocking the potential of two-dimensional searches.

Module 5: XLOOKUP
Wrap up the course by mastering XLOOKUP, Excel’s most powerful lookup tool. Explore its versatile features, including error handling, reverse lookups, and multi-condition searches, to simplify complex tasks.

This course is perfect for students, professionals, and anyone looking to elevate their Excel skills!

BONUS: This course also features a bonus tutorial on fundamental Excel formulas you may or may not be familiar with, designed to strengthen your overall understanding of how functions operate

Who this course is for:

Beginners in Excel Data Analysis
Students and Educators
Small Business Owners and Entrepreneurs
Business Analysts and Data Professionals

Introduction to Excel Lookup Functions

What you'll learn

Explore related topics

Course content

Basic Math and Logic Functions4 lectures • 14min

Text Handling and Cleaning3 lectures • 9min

Date and Time2 lectures • 5min

Conditional Calculations2 lectures • 6min

Introduction to Lookup Functions3 lectures • 4min

Lookup Functions Overview1 lecture • 4min

HLOOKUP & VLOOKUP6 lectures • 15min

Exact and Appropriate Match with Absolute and Dynamic Referencing5 lectures • 14min

Index Match and Index Double Match3 lectures • 13min

XLOOKUP and XMATCH4 lectures • 9min

Requirements

Description

Who this course is for: