Master Lookup Functions in Excel

Paula

28 CQ

7 Lessons

Course Info

Previous...

Playing

6 CQ

1. The Fundamentals of VLOOKUP in Excel
A lesson with Paula

View lesson

Need to know the basics of the VLOOKUP function in Microsoft Excel? In this lesson, learn how to use VLOOKUP exact match and approximate match.

The Fundamentals of VLOOKUP in Excel

with Paula

Need to know the basics of the VLOOKUP function in Microsoft Excel? In this lesson, learn how to use VLOOKUP exact match and approximate match.
Playing

6 CQ

2. How to Use Index & Match in Excel
A lesson with Paula

View lesson

In this Excel spreadsheets lesson, get an explanation of the match and index functions before learning practical, everyday examples for using both functions.

How to Use Index & Match in Excel

with Paula

In this Excel spreadsheets lesson, get an explanation of the match and index functions before learning practical, everyday examples for using both functions.
Playing

2 CQ

3. Combining INDEX & MATCH Functions
A lesson with Paula

View lesson

In this advanced Excel or Google Sheets lesson, learn how to perform a lookup that returns values from the left by combining INDEX and MATCH.

Combining INDEX & MATCH Functions

with Paula

In this advanced Excel or Google Sheets lesson, learn how to perform a lookup that returns values from the left by combining INDEX and MATCH.
Playing

2 CQ

4. Combining VLOOKUP with MATCH in Excel
A lesson with Paula

View lesson

In this Excel spreadsheets lesson, learn how to combine the VLOOKUP function with the MATCH function to create a more dynamic and robust formula.

Combining VLOOKUP with MATCH in Excel

with Paula

In this Excel spreadsheets lesson, learn how to combine the VLOOKUP function with the MATCH function to create a more dynamic and robust formula.
Playing

3 CQ

5. Combining the VLOOKUP & MID Function
A lesson with Paula

View lesson

Learn how to extract specific text from a string and combine it with the VLOOKUP function in this Excel spreadsheet lesson about the MID function.

Combining the VLOOKUP & MID Function

with Paula

Learn how to extract specific text from a string and combine it with the VLOOKUP function in this Excel spreadsheet lesson about the MID function.

More...

Recommended Recommended
History & In Progress History
Browse Library
Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

You don't have any lessons in your history.
Just find something that looks interesting and start learning!