IntermediateLookup & Reference
Look up a unit price with VLOOKUP
Use VLOOKUP with exact match to pull prices from a product table.
VLOOKUP
8 min25 points
Look up a customer's region with XLOOKUP
The situation
Harbor Supply's order export lists customer IDs but not regions. The regions live in a separate reference table, and the weekly report needs them joined together.
A1
fx
| Row number | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Customer ID | Region | Customer ID | Region | |||
| 2 | ORD-1041 | CUST-204 | CUST-118 | East | ||||
| 3 | ORD-1042 | CUST-118 | CUST-204 | West | ||||
| 4 | ORD-1043 | CUST-377 | CUST-291 | North | ||||
| 5 | CUST-377 | South | ||||||
| 6 | CUST-402 | West | ||||||
| 7 |
Functions in this exercise
- XLOOKUP — Finds a value in one range and returns the matching value from another — in any direction.
Who this is for
Recommended next
Related exercises
- IntermediateLookup & Reference
Look up a unit price with VLOOKUP
Use VLOOKUP with exact match to pull prices from a product table.
VLOOKUP
8 min25 points - IntermediateLookup & Reference
Find a value with INDEX and MATCH
Combine INDEX and MATCH to look up a value without a fixed column number.
INDEX · MATCH
10 min25 points - AdvancedLookup & Reference
Lock ranges so a lookup survives fill-down
Use absolute references so a lookup does not break when copied down a column.
XLOOKUP
12 min40 points