INDEX function

INDEX returns the contents of a cell, specified by row and column number or an optional range name.

Syntax

INDEX(reference, row, column, range)

  • reference is a cell reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the reference or range name in parentheses.
  • row (optional) represents the row number of the reference range, for which to return a value.
  • column (optional) represents the column number of the reference range, for which to return a value.
  • range (optional) represents the index of the subrange if referring to a multiple range.

Example

=INDEX(A1:B6,1,1) returns the value at the beginning of the A1:B6 range.