INDEX Function
Purpose
Returns the value of a cell within an array or range based on row and column coordinate numbers.
Syntax
EXCEL
=INDEX(array, row_num, [column_num])
Returns the value of a cell within an array or range based on row and column coordinate numbers.
=INDEX(array, row_num, [column_num])