Skip to content

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

Lesson 5/5

When a lookup finds nothing

Exercise 1 of 3

In F2, look up the price for the code in E2 with VLOOKUP, and show 0 if it isn't found.

About this lesson

When a lookup finds nothing it returns #N/A. Learn to show your own result instead with IFERROR and IFNA.

In this lesson

  1. In F2, look up the price for the code in E2 with VLOOKUP, and show 0 if it isn't found.
  2. In F2, look up the product name for the code in E2. Use IFNA to show "not found" if the code is missing.
  3. You leave out the last argument: =VLOOKUP(E2,A2:C7,3). What happens?

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

Type in F2 and press Enter to check.