Exercises / Lookups · 10 of 10
A lookup that never shows #N/A
Older workbooks wrap VLOOKUP in IFERROR to replace #N/A with a message: =IFERROR(VLOOKUP(…), "Not listed"). You will see this pattern everywhere, even though XLOOKUP has the fallback built in.
Your taskIn F2, use VLOOKUP to look up the price of the code in E2 in the table A2:B8 (exact match), and IFERROR to return "Not listed" when the code is missing.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Code | Price | Code | Price | ||
| 2 | SKU-11 | $9.90 | SKU-15 | |||
| 3 | SKU-12 | $14.50 | ||||
| 4 | SKU-14 | $7.25 | ||||
| 5 | SKU-15 | $22.00 | ||||
| 6 | SKU-17 | $5.60 | ||||
| 7 | SKU-18 | $31.40 | ||||
| 8 | SKU-20 | $18.75 |