INDEX Function

About

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

Purpose

To choose a value from a list or array

Return value

Value at the given position

Syntax

Index function has two forms

=INDEX(array,row_num,[col_num])
=INDEX(reference,row_num,[col_num],[area_num])

Arguments

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


Notes

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