IFNA
Shows a replacement only for #N/A errors.
How it’s written
IFNA(formula, if_na)Example
| A | B | C | |
|---|---|---|---|
| 1 | Code | Product | Price |
| 2 | P-10 | Lamp | 45 |
| 3 | P-20 | Desk | 210 |
| 4 | P-30 | Chair | 120 |
=IFNA(VLOOKUP("P-99",A2:C4,3,FALSE),"Not found")Result: Not found
P-99 isn’t in the list, so it shows the message.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Safer than IFERROR around lookups, because other errors still show up.
Practice it properly
Handling errors and gaps gives you real tasks, with your formulas tested on data you haven’t seen.