IFERROR
Replace formula errors with a useful result
0 of 3 done · Lesson 14 of 18
Understand
A stock report is shared with people who do not need to decode #N/A. IFERROR tries the calculation and replaces an error with text they can act on.
=IFERROR(formula to try, what to show if it fails)
A worked example
=IFERROR(VLOOKUP(F2, A2:C7, 3, FALSE), "Not listed")
formula to trywhat to show if it fails
This returns 92.5
The sheet you are working with
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | SKU | Product | Price | Stock | Find SKU | P-99 |
| 2 | P-14 | Monitor arm | 63.5 | 12 | Find SKU | P-42 |
| 3 | P-21 | Dock | 184 | 8 | ||
| 4 | P-35 | Laptop | 1289 | 3 | ||
| 5 | P-42 | Headset | 92.5 | 17 | ||
| 6 | P-58 | Keyboard | 118 | 9 | ||
| 7 | P-73 | Webcam | 147 | 0 |