Excel Lookup & Reference Functions for Beginners: VLOOKUP, XLOOKUP, and more in 35 minutes!

Learn Microsoft Excel lookup and reference functions in just 35 minutes!

What are lookup and reference functions?

Lookup and reference functions are Excel functions that allow you to search, join, and find information about data.

Why should you learn lookup and reference functions in Excel?

There's a range of reasons why you should learn lookup and reference functions in Microsoft Excel as they're useful for:

• Combining data sets
• Retrieving information about data
• Finding missing data values
• And more!

Many employers will even request knowledge of certain Excel lookup functions in job specifications and knowing how to use them will be useful for a range of tasks.

What will I know at the end of this class?

• How to use popular lookup and reference functions including VLOOKUP, XLOOKUP, and more!
• Best practices for using lookup and reference functions
• Strengths and weaknesses of different functions
• How to avoid mistakes and errors when using lookup and reference functions

Interested in learning more about Excel? Check out my other classes:

• Excel for Beginners: Learn The Essentials in 50 Minutes
• Excel Formulas You Need to Know in 30 Minutes
• Excel Pivot Tables for Beginners: Learn them in 20 Minutes
• Excel Text Functions: Learn them in 30 Minutes

• Intro: Why Learn Lookup & Reference Functions?
• Getting Started with the VLOOKUP Function
• Ensuring Table Arrays are Locked
• Ensuring Consistencies with Lookup Values
• When to Use Approximate Match Lookups
• The HLOOKUP function
• The INDEX function
• The MATCH function
• How and Why to Combine INDEX and MATCH
• The XLOOKUP Function
• Using XLOOKUP's 'If Not Found' Feature
• Using XLOOKUP's 'Exact' Match Modes
• Using XLOOKUP's 'Wildcard' Match Mode
• Changing XLOOKUP's Search Mode
• How to Use XLOOKUP for Horizontal Lookups
• Using XLOOKUP for a Lookup Array to the Right
• Next Steps