Work

# Master Lookup Functions in Excel

28 CQ
7 Lessons
Previous...
• Playing
6 CQ
1. The Fundamentals of VLOOKUP in Excel
A lesson 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.

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

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

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

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.

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

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

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

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.

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.

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