Excel: Lookup Functions in Depth

Introduction

• Transform your Excel skills with in-depth lookup functions

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

• Locating data with the MATCH and XMATCH functions
• Retrieving information by location with the INDEX function
• Using the XMATCH and INDEX functions together

2. VLOOKUP, HLOOKUP, and XLOOKUP

• Structuring data for use with lookup functions
• Finding exact and approximate matches with VLOOKUP and HLOOKUP
• Using the XLOOKUP function for exact matches
• Using the XLOOKUP function for approximate matches
• New and expanded capabilities using XLOOKUP

3. Finding Matching Data Without Using External Lists

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

4. Other Functions with Lookup Capabilities

• Extracting and counting unique entries using the UNIQUE function
• Using FILTER and CHOOSECOLS for multiple column retrieval
• Use the SORT and SORTBY functions to create new lists
• Use the INDIRECT function to return references specified by text strings

5. Recently Introduced Functions with Lookup Capabilities

• CHOOSEROWS and CHOOSECOLS: Return lists with selected rows or columns
• TAKE and DROP: Copy from lists selecting or ignoring consecutive rows or columns
• TOROW and TOCOL: Convert array data into a single row or column
• WRAPROWS and WRAPCOLS: Convert row or column data into an array
• VSTACK and HSTACK: Stack multiple arrays into a vertical or horizontal array

Conclusion

• Your next steps in Excel