LOOKUPS & REFERENCES · ORIGINAL EXERCISE
An ancient combination
Find the price of "DK-06" using INDEX with MATCH.
This quest practices INDEX + MATCH using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| SKU | Item | Stock | Reorder at | Price |
|---|---|---|---|---|
| KB-01 | Keyboard | 24 | 10 | 60 |
| MS-02 | Mouse | 8 | 15 | 25 |
| MN-03 | Monitor | 6 | 8 | 250 |
| HC-04 | Headset | 18 | 12 | 80 |
| WB-05 | Webcam | 0 | 5 | 45 |
| DK-06 | Dock | 12 | 6 | 110 |
Hints to get you started
- MATCH finds the row’s position.
- INDEX uses that position to return a price.
- Use exact-match mode 0 in MATCH.
Show the worked solution
=INDEX(E2:E7,MATCH("DK-06",A2:A7,0))INDEX/MATCH works without requiring the lookup column to be first in a larger table.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →