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.

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides