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
Look up a unit price with VLOOKUP
The situation
You are rebuilding a quote for Harbor Supply. The item codes are on the quote but the prices sit in the product master, and the customer is waiting.
A1
fx
| Row number | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Line | Item code | Unit price | Item code | Price | |||
| 2 | 1 | HSC-04182 | HSC-04182 | $18 | ||||
| 3 | 2 | HSC-77213 | HSC-11904 | $32 | ||||
| 4 | 3 | HSC-11904 | HSC-33027 | $9 | ||||
| 5 | HSC-77213 | $46 | ||||||
| 6 | HSC-90114 | $12 | ||||||
| 7 |
Functions in this exercise
- VLOOKUP — Finds a value in the first column of a table and returns a value from another column.
Who this is for
Recommended next
Related exercises
- IntermediateLookup & Reference
Look up a customer's region with XLOOKUP
Match a customer ID against a reference table to return their region.
XLOOKUP
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