Excel: Lookup Functions in Depth

Contents

• Introduction Introduction

  • Introduction

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

  • Locate data with the MATCH function

    4m 12s
  • Retrieve information by location with the INDEX function

    4m 34s
  • Use the MATCH and INDEX functions together

    3m 29s
  • Use the new XMATCH function: Expanded and improved MATCH

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

  • Structure data for use with lookup functions

    3m 37s
  • Find approximate and exact matches with VLOOKUP and HLOOKUP

    5m 29s
  • Use the new XLOOKUP function for exact matches

    3m 30s
  • Use the new XLOOKUP function for approximate matches

    2m 53s
  • New and expanded capabilities using XLOOKUP

    5m 23s
• 3. Finding Matching Data without Using External Lists 3. Finding Matching Data without Using External Lists

  • Find table-like information within a function using CHOOSE

    5m 27s
  • Use the SWITCH function for formula-embedded selection

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

  • Extract and count unique entries from a list using the UNIQUE function

    5m 8s
  • Filter data and return matching records with the FILTER function

    4m 46s
  • Use the SORT and SORTBY functions to create new lists

    5m 29s
  • Use INDIRECT to return references specified by text strings

    4m 3s
• Conclusion Conclusion

  • Next steps

    32s