Transform your Excel skills with in-depth lookup functions - Microsoft Excel Tutorial

Contents

• Introduction Introduction

  • Transform your Excel skills with in-depth lookup functions

    32s
• 1. Locating Data with MATCH, INDEX, and XMATCH Functions 1. Locating Data with MATCH, INDEX, and XMATCH Functions

  • Locating data with the MATCH and XMATCH functions

    5m 24s
  • (Locked)
    Retrieving information by location with the INDEX function

    4m 26s
  • (Locked)
    Using the XMATCH and INDEX functions together

    5m 43s
• 2. VLOOKUP, HLOOKUP, and XLOOKUP 2. VLOOKUP, HLOOKUP, and XLOOKUP

  • Structuring data for use with lookup functions

    3m 54s
  • (Locked)
    Finding exact and approximate matches with VLOOKUP and HLOOKUP

    5m 4s
  • (Locked)
    Using the XLOOKUP function for exact matches

    3m 41s
  • (Locked)
    Using the XLOOKUP function for approximate matches

    3m 27s
  • (Locked)
    New and expanded capabilities using XLOOKUP

    5m 54s
• 3. Finding Matching Data Without Using External Lists 3. Finding Matching Data Without Using External Lists

  • (Locked)
    Finding table-like information within a function using the CHOOSE function

    5m 3s
  • (Locked)
    Using the SWITCH function for formula-embedded selection

    4m 19s
• 4. Other Functions with Lookup Capabilities 4. Other Functions with Lookup Capabilities

  • (Locked)
    Extracting and counting unique entries using the UNIQUE function

    5m 5s
  • (Locked)
    Using FILTER and CHOOSECOLS for multiple column retrieval

    6m 14s
  • (Locked)
    Use the SORT and SORTBY functions to create new lists

    6m 34s
  • (Locked)
    Use the INDIRECT function to return references specified by text strings

    4m 56s
• 5. Recently Introduced Functions with Lookup Capabilities 5. Recently Introduced Functions with Lookup Capabilities

  • (Locked)
    CHOOSEROWS and CHOOSECOLS: Return lists with selected rows or columns

    6m 18s
  • (Locked)
    TAKE and DROP: Copy from lists selecting or ignoring consecutive rows or columns

    4m 11s
  • (Locked)
    TOROW and TOCOL: Convert array data into a single row or column

    4m 39s
  • (Locked)
    WRAPROWS and WRAPCOLS: Convert row or column data into an array

    5m 1s
  • (Locked)
    VSTACK and HSTACK: Stack multiple arrays into a vertical or horizontal array

    4m 26s
• Conclusion Conclusion

  • (Locked)
    Your next steps in Excel

    35s