Excel > Functions

INDEX Function

The INDEX function returns an item from a specific position in a list.

The syntax for the INDEX function is:

=INDEX(array, row_num, [column_num])




The range of cells where the item can be found


The row where the item you want returned can be found


The column where the item you want returned can be found.

If the array is only 1 column wide, this argument can be omitted

The example below demonstrates the INDEX function being used to return the item in the 3rd row and 2nd column.

How to use the INDEX function

Follow us on

Facebook  Twitter  You Tube 

Other Lookup & Reference Functions

Excel 2010 Superhero Course