INDEX Function in Excel
The Index Function returns the value of an array given a specific row and column.
INDEX(array, row_num, [column_num])
- array – this is a range of cells that you want to return a value from.
- row_num – the row number in array from which you want to return a value. If omitted, the column_num is required.
- column_num – the column number in array from which you want to return a value. If omitted, row_num is required.
Using the formula above, we set the search feature look from cells A2 through C12. Next, we want to return the value from Row 5, Column 2 (B).
The end result is Alabama.