INDEX Function Explained
The INDEX function in Microsoft Excel is used to return a value or the reference to a value from within a table or range. It has two forms: INDEX(array, row_num, [column_num]) and INDEX(reference, row_num, [column_num], [area_num]). The first form returns the value of an element in a given array, while the second form returns the reference to a value in a given reference.
INDEX Function Syntax
INDEX(array, row_num, [column_num])
- array: The range of cells to be evaluated by the function.
- row_num: The row number in the array from which to return a value.
- column_num: (Optional) The column number in the array from which to return a value.