Stage 2 · Lesson 3 of 6
Lookups with XLOOKUP
Analysis often needs a value from another table: a customer's region, a product's category, a price on a certain date. does this in current and . It finds a key (an ID such as a customer number) in one column and returns the matching value from another.
It also lets you say what to show when nothing matches. It replaces most uses of the older VLOOKUP and of INDEX with MATCH, and it does not break when someone inserts a column. A lookup is the spreadsheet version of a , which you will do in next.
Common trapnot checking unmatched keys: if 8 percent of rows return "Not found", your later totals by region are incomplete, and it usually means the keys are messy and need cleaning first.
A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock
Resources for this stage
Start with
- GuideFreeExcel help and learning
Microsoft · Beginner
Official, accurate guides to XLOOKUP, SUMIFS, PivotTables and cleaning functions, with examples you can paste