easyLazada · lookup
Look up a product's price by SKU
Columns A-B list Lazada product SKUs and their prices, in no particular order. Write a formula in D1 that returns the price for SKU LZD-2203.
Starting grid
A1
| A | B | C | D | |
|---|---|---|---|---|
| 1 | LZD-2203 | 89.00 | ||
| 2 | LZD-2201 | 49.90 | ||
| 3 | LZD-2205 | 5.90 | ||
| 4 | LZD-2202 | 15.50 | ||
| 5 | LZD-2204 | 22.30 |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
D1
| A | B | C | D | |
|---|---|---|---|---|
| 1 | LZD-2203 | 89.00 | ||
| 2 | LZD-2201 | 49.90 | ||
| 3 | LZD-2205 | 5.90 | ||
| 4 | LZD-2202 | 15.50 | ||
| 5 | LZD-2204 | 22.30 |