Index Function

INDEX returns a value at a given position in a range or array.

INDEX (array, row_num, [col_num])
returns the value in the cell at the intersection of row_num and column_num.

INDEX(reference, row_num, [column_num], [area_num])
returns the reference of the cell at the intersection row_num and column_num.

INDEX: Click to enlarge picture