Excel Function : INDEX
Lookup and reference
Uses an index to choose a value from a reference or array
Microsoft Excel Reference Page
Syntax and Description of the INDEX Excel Function
The INDEX function is used to return a value or reference to a value from a table or range of cells. The syntax for the INDEX function is as follows: = INDEX (array, row_num, column_num) where array is the range of cells to be searched, row_num is the row number in the array to return a value from, and column_num is the column number in the array to return a value from.
About INDEX Excel Function
The INDEX function returns a value or the reference to a value from within an array or range of cells. Array form: INDEX(array, row_num, column_num) Reference form: INDEX(reference, row_num, column_num, [area_num]) The array form returns the value in the array at the intersection of row_num and column_num. The reference form returns the reference to the cell at the intersection of row_num and column_num in reference. If reference is a range of cells, and area_num is omitted, INDEX returns the reference as a whole. If reference is a range of cells, and area_num is included,