Mastering Lookup Functions in Excel: Seven Powerful Formulas

Course details

Dive into the world of Excel lookup functions in this engaging crash course designed to enhance your data handling and data management skills. Join instructor Josh Aharonoff—also known as Your CFO Guy, who has hundreds of thousands of professional online followers on social media—as he offers an in-depth exploration of Excel's most widely used and important lookup functions.

Gain insights into a broad range of topics, such as detailed function syntax and the pros and cons of each function, along with practical exercises that will empower you to leverage your data more effectively. By the end of this course, you’ll be prepared to start using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, the powerful INDEX/MATCH combination, and GETPIVOTDATA. Whether you're just getting started or looking to refine your skills, this course is tailored to help you navigate your datasets with ease and greater confidence.

Concepts

Introduction

Take your Excel game to the next level with lookup functions
What are lookup functions

VLOOKUP

Find values vertically with VLOOKUP
VLOOKUP pros and cons
Challenge - Master VLOOKUP
Solution - Master VLOOKUP

HLOOKUP

Locate values horizontally with HLOOKUP
HLOOKUP pros and cons
Challenge - Master HLOOKUP
Solution - Master HLOOKUP

XLOOKUP

Find values flexibly with XLOOKUP
XLOOKUP pros and cons
How to nest with XLOOKUP
Challenge - Create a basic XLOOKUP
Solution - Create a basic XLOOKUP
Challenge - Create a nested XLOOKUP
Solution - Create a nested XLOOKUP

INDEX

Discover values with cell references using INDEX
INDEX pros and cons
Challenge - Master the INDEX function
Solution - Master the INDEX function

MATCH

Find the position of a value using MATCH
MATCH pros and cons
Challenge - Find the month difference with MATCH
Solution - Find the month difference with MATCH

INDEX and MATCH

Unleash the power of INDEX and MATCH
INDEX and MATCH pros and cons
Challenge - Find a value with INDEX and MATCH
Solution - Find a value with INDEX and MATCH

GETPIVOTDATA

Find a PivotTable value with GETPIVOTDATA
What are the pros and cons of GETPIVOTDATA
Challenge - Master the GETPIVOTDATA function
Solution - Master the GETPIVOTDATA function

Conclusion

Which lookup function should you use
Take your skills to the next level with other functions