index function

Description

This INDEX function return the value at a given position in a range or array. You can use indext to retrieve individual values or entire rows and columns. Index is often used with the MATCH function, where MATCH locates and feeds a position to INDEX.

​

Objective

Obtain a value in a list or table based on location.

​

Syntax

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

​

Arguements

array - Range of cells or an array constant.

row_num - Row position in the reference or array.

row_num - [optional] Column position in the reference or array.

row_num - [optional] Range in reference that should be used.

​