Price Check
Your client runs a small shop with a price list: one row per item, with its price. The list is in no particular order. Given the item named in the Wanted item cell, produce its price — a single number.
The wanted item always appears in the list exactly once. Watch out: some item names share their first word, and the list is not sorted, so your lookup has to match the whole name exactly.
Work on it
- Make a copy of the template — it becomes your private sheet.
- Solve it however you like — helper columns and extra tabs are fair game. The one rule:
the grader swaps
INPUTfor other datasets, so never put your own content insideINPUT. - Check yourself against the expected sample output shown in your copy (and below).
- Submit below — Share → "anyone with the link, Viewer", paste the link. Your sheet is graded against 3 hidden datasets, so hardcoded answers won't survive.
Sample
Input (Input!B2:E32)
| Item | Price | Wanted item | |
| Lamp | 34.5 | Mirror | |
| Desk | 120 | ||
| Chair | 89.99 | ||
| Rug | 45 | ||
| Shelf | 60 | ||
| Stool | 25 | ||
| Mirror | 78 | ||
| Vase | 19.5 |
Expected output (Answer!B3:B3)
| Price |
|---|
| 78 |