Practice challenge
Look up price with a fallback
#26
3 attempts remaining
IntermediateProduct pricingTarget B2
A quote sheet should return a product price or Not found when the code is missing.
Write a formula for B2 that looks up A2 in D2:E5 and returns "Not found" if it is missing.
Look up price with a fallback
Swipe horizontally to view the full table.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| # | Product code | Price | Reference | Lookup code | Lookup price |
| 2 | KIT-03 | blank | blank | TEA-01 | 12 |
| 3 | MUG-02 | blank | blank | MUG-02 | 8 |
| 4 | BAG-04 | blank | blank | KIT-03 | 35 |
| 5 | blank | blank | blank | BAG-04 | 3 |