Master Lookup Functions in Excel

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!

    Comments
    500 characters max