Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

INDEX Function

The INDEX function is one of the lookup and reference functions. It is used to return a value within a range of cells on the base of a specified row and column number. The INDEX function has two forms.

The INDEX function syntax in the array form is:

INDEX(array, row_num, [column_num])

The INDEX function has the following arguments:

Argument Description
array A range of cells.
row_num A row number you wish to return a value from. If it is omitted, column_num is required.
column_num A column number you wish to return a value from. If it is omitted, row_num is required.

The INDEX function syntax in the reference form is:

INDEX(reference, row_num, [column_num], [area_num])

The INDEX function has the following arguments:

Argument Description
reference A reference to a range of cells.
row_num A row number you wish to return a value from. If it is omitted, column_num is required.
column_num A column number you wish to return a value from. If it is omitted, row_num is required.
area_num An area to use in case the array contains several ranges. It is an optional argument. If it is omitted, the function will assume area_num to be 1.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the INDEX function.

Examples

The figure below displays the result returned by the INDEX function.

INDEX Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action