0:00 / 10:39
 
 
 
 

Master Lookup Functions in Excel

28 CQ
7 Lessons
Course Info
  • 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...