Logical FunctionsIntermediate

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.

Interactive Spreadsheet

Read about IFNA

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of IFNA

0/3

The same formula in the other shapes it takes at work.

  1. IFNA Function

    Handle #N/A errors specifically using IFNA.

    CoreIntermediate
  2. IFNA around MATCH

    Where is it in the list — or is it not there at all?

    Intermediate
  3. IFNA as a default inside a calculation

    A missing lookup becomes a sensible default, and the arithmetic carries on.

    Advanced

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.

5 rows × 5 columns4 cells you fill in
ABCDE
1ProductPricePrice List
2AppleApple2.5
3BananaBanana1.8
4OrangeOrange3.2
5GrapeMango4

Functions used here

What this exercise teachesMay contain the answer

IFNA function specifically handles #N/A errors, commonly returned by lookup functions like VLOOKUP when a value is not found.