INDEX Function - Excel
Overview
The INDEX function in Excel is a useful tool for returning the value of a cell in a specified row and column within a given range or array. This function provides a flexible way to retrieve data based on the intersection of a specified row and column position.
Example:
=INDEX(C2:E6, 3, 1)
Syntax:
=INDEX(array, row_num, [column_num])
array: The range or array from which to retrieve the value.
row_num: The row number within the array from which to retrieve the value.
[column_num]: An optional argument. The column number within the array from which to retrieve the value. If omitted, only the row is considered.
Example
In the example above, the INDEX function looks at the table in C2:E6 and returns the value that is in the 3rd row and the 1st column. The final output of this function is “Bike”.