Skip to content

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

Lesson 2/4

MATCH: find the position

Exercise 1 of 3

In F2, find the position of the code in E2 within A2:A7.

About this lesson

MATCH finds where a value sits in a range and returns its position as a number.

In this lesson

  1. In F2, find the position of the code in E2 within A2:A7.
  2. In F2, find the position of the product name in E2.
  3. What does the 0 at the end of MATCH(E2,A2:A7,0) mean?

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.