IFERROR practice exercises
Shows a fallback when a formula errors. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 4801 | East | Kofi | 9 | 9 | 81 |
| 3 | 4802 | West | Omar | 4 | 45 | 180 |
| 4 | 4803 | West | Ana | 7 | 9 | 63 |
| 5 | 4804 | South | Omar | 6 | 9 | 54 |
| 6 | 4805 | East | Ines | 2 | 30 | 60 |
| 7 | 4806 | West | Kofi | 5 | 15 | 75 |
| 8 | 4807 | South | Ines | 8 | 12 | 96 |
| 9 | 4808 | South | Ines | 7 | 30 | 210 |
Order 4832 doesn’t exist. Look up its Price with VLOOKUP, but show "Not found" instead of an error.
Show answer
=IFERROR(VLOOKUP(4832,A2:F9,5,FALSE),"Not found")→ Not foundOrder 4827 doesn’t exist. Look up its Price with VLOOKUP, but show "Not found" instead of an error.
Show answer
=IFERROR(VLOOKUP(4827,A2:F9,5,FALSE),"Not found")→ Not foundOrder 4834 doesn’t exist. Look up its Price with VLOOKUP, but show "Not found" instead of an error.
Show answer
=IFERROR(VLOOKUP(4834,A2:F9,5,FALSE),"Not found")→ Not foundOrder 4816 doesn’t exist. Look up its Price with VLOOKUP, but show "Not found" instead of an error.
Show answer
=IFERROR(VLOOKUP(4816,A2:F9,5,FALSE),"Not found")→ Not foundOrder 4839 doesn’t exist. Look up its Price with VLOOKUP, but show "Not found" instead of an error.
Show answer
=IFERROR(VLOOKUP(4839,A2:F9,5,FALSE),"Not found")→ Not foundOrder 4823 doesn’t exist. Look up its Price with VLOOKUP, but show "Not found" instead of an error.
Show answer
=IFERROR(VLOOKUP(4823,A2:F9,5,FALSE),"Not found")→ Not found
New to IFERROR? Read the IFERROR guide first: syntax, a worked example and common mistakes.