Excel Practice - IFERROR
Instruction
Try VLOOKUP for code "P-999" in A2:C6; if it errors, return "Not found".
Formula Syntax
=IFERROR(value, value_if_error)
- value: Input value or expression.
- value_if_error: Fallback value returned when the main expression errors.
What it does
Return fallback output when a formula throws an error.
lookup-reference-table.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Code | Name | Price |
| 2 | P-101 | Mouse | 19 |
| 3 | P-102 | Keyboard | 45 |
| 4 | P-103 | Monitor | 199 |
| 5 | P-104 | USB Hub | 29 |
| 6 | P-105 | Headset | 59 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use IFERROR with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.