LOOKUPS & REFERENCES · ORIGINAL EXERCISE
Look to the left
Return the SKU for item "Webcam". Search B2:B7 and return from A2:A7.
This quest practices Left lookups 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
- XLOOKUP can return data to the left.
- Search item names, return SKUs.
- Keep the search and return ranges aligned.
Show the worked solution
=XLOOKUP("Webcam",B2:B7,A2:A7)Unlike classic VLOOKUP, XLOOKUP does not require the return column to be on the right.
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 →