Excel: Lookup Functions in Depth

Introduction

• Introduction

1. Locating Data with MATCH, INDEX, and XMATCH Functions

• Locate data with the MATCH function
• Retrieve information by location with the INDEX function
• Use the MATCH and INDEX functions together
• Use the new XMATCH function: Expanded and improved MATCH

2. VLOOKUP, HLOOKUP, and XLOOKUP

• Structure data for use with lookup functions
• Find approximate and exact matches with VLOOKUP and HLOOKUP
• Use the new XLOOKUP function for exact matches
• Use the new XLOOKUP function for approximate matches
• New and expanded capabilities using XLOOKUP

3. Finding Matching Data without Using External Lists

• Find table-like information within a function using CHOOSE
• Use the SWITCH function for formula-embedded selection

4. Other Functions with Lookup Capabilities

• Extract and count unique entries from a list using the UNIQUE function
• Filter data and return matching records with the FILTER function
• Use the SORT and SORTBY functions to create new lists
• Use INDIRECT to return references specified by text strings

Conclusion

• Next steps