Table of Contents
Summary
The INDEX function returns a specific value across a given row and column of data. The Excel INDEX function is not commonly used on it’s own, but is very commonly used with the MATCH function as part of an INDEX MATCH formula.
Formula
=INDEX(array, row_num, [column_num])
Arguments (inputs)
array = the array of data from which the result will be returned
row_num = the row number of the desired data to return
column_num = [optional] the column number of the desired data to return
Return value
The INDEX function will return the value from the provided row (and column, if applicable) from an array of data. If column_num is left blank then the default is 1 (first column).
Example
In the example above the INDEX function returns the value from row 4 (cell reference H6) of the array C6:C16.
=INDEX(C6:C16, H6)
The function returns the value “Thomson” from row 4 of the array.
