Excel INDEX function

Function              INDEX

Description        Excel INDEX function returns a value or reference of the cell at the intersection of a particular row and column, in a given range.

Syntax  INDEX(array, row_num, [column_num])

array  A range of cells, or reference to cell.

row_num  The row position in the reference or array.

col_num  [optional] The column position in the reference or array.