Overview
-
Master some of the most powerful lookup functions in Microsoft Excel, including VLOOKUP, INDEX, XMATCH, and XLOOKUP.
Syllabus
-
Introduction
- Introduction
- 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
- 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
- Find table-like information within a function using CHOOSE
- Use the SWITCH function for formula-embedded selection
- 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
- Next steps
