Skip to content

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

Lesson 1/5

VLOOKUP: find a value in a table

Exercise 1 of 3

In F2, look up the price of the product code in E2.

About this lesson

VLOOKUP finds a value in the first column of a table and returns something from the same row, such as the price for a product code.

In this lesson

  1. In F2, look up the price of the product code in E2.
  2. In F2, look up the product name for the code in E2.
  3. The code in E2 isn't in the table. What does =VLOOKUP(E2,A2:C7,3,FALSE) give?

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.