Introduction to Excel Formulas and Lookup Functions

Name: Introduction to Excel Formulas and Lookup Functions
Rating: 4.7 (161 reviews)

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

Created byAliyu Nasir Musa

Last updated 6/2026

English

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

8 sections • 29 lectures • 1h 22m total length

SUM TOTAL, AVERAGE, MIN and MAX3:15
Introduction to these formulas, their functions and how to use them
COUNT and COUNTA3:07
Logic Functions (IF, AND OR and NOT)3:54
Error Handling (IFERROR & IFNA)3:26

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
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.

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!

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 Formulas and Lookup Functions

What you'll learn

Explore related topics

Course content

Basic Math and Logic Functions4 lectures • 14min

Text Handling and Cleaning3 lectures • 9min

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: