Skip to content

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

Lesson 1/4

INDEX: pick by position

Exercise 1 of 3

In F2, use INDEX to show the 3rd price in C2:C7.

About this lesson

INDEX returns the value at a given position in a range, such as the 3rd item in a list.

In this lesson

  1. In F2, use INDEX to show the 3rd price in C2:C7.
  2. In F2, use INDEX on the whole table A2:C7 to show the product in the table's 5th row and 2nd column.
  3. What does =INDEX(B2:B7,1) 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.