INDEX Function


INDEX function in Excel can be used to return a value at the given position of a list or a table.

Function Type

Lookup and reference


To choose a value from a list or array

Return value

Value at the given position


Index function has two forms



Array – The range of cells containing values.

row_num – The number of the row from which you want to return the value

col_num – [optional] The number of the column from which to return the value

area_num – [optional] Used to select the range in reference from which to return the intersection of row_num and column_num. The first area is numbered 1, the second is 2, and so on. Default value is 1.

Example 1

Example 2

Example 3


INDEX function is often combined with MATCH function to create a powerful and flexible alternative to VLOOKUP function.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel