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])

Argument

Purpose

array

The range of cells where the item can be found

row_num

The row where the item you want returned can be found

column_num

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