Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 2/4

#N/A: nothing found

Exercise 1 of 3

F2 looks up the price for the code in E2 and shows #N/A. Why?

About this lesson

#N/A means a lookup didn't find what it was looking for. Check where it searches, or give it something to show when the value really is missing.

In this lesson

  1. F2 looks up the price for the code in E2 and shows #N/A. Why?
  2. F2 should show the price for code P20 but shows #N/A: it searches the wrong column. Fix the formula in F2.
  3. Code P50 really doesn't exist, so F2 shows #N/A. Fix the formula so it shows "not found" instead.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Try it out: type a formula in any free cell or change a value. What you type on the sheet isn’t graded.