Logical Functions
Intermediate
IFNA Function
Handle #N/A errors specifically using IFNA.
Task:
You are using VLOOKUP to find product prices, but some products are not listed in the price table. Use VLOOKUP with IFNA to handle missing values and display 'Not Found' instead of #N/A in column B.
Learning Objectives:
- Learn IFNA function
- Understand specific error handling for #N/A
- Practice lookup error management
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Price | Price List | ||
| 2 | Apple | Apple | 2.5 | ||
| 3 | Banana | Banana | 1.8 | ||
| 4 | Orange | Orange | 3.2 | ||
| 5 | Grape | Mango | 4 |
What this exercise teaches (contains the answer)
IFNA function specifically handles #N/A errors, commonly returned by lookup functions like VLOOKUP when a value is not found.