INDEX

Returns the content of a cell specified by row and column offset.

Examples

Make a copy

Returns the content of a cell, specified by row and column number or an optional range name.

Sample usage

INDEX(A1:C20, 5, 1)

Syntax

INDEX(reference, [row], [column])

  • reference – The array of cells to be offset into.

  • row[OPTIONAL – 0 by default] – The number of offset rows.

  • column[OPTIONAL – 0 by default] – The number of offset columns.

See also

MATCH: Returns the relative position of an item in a range that matches a specified value.

OFFSET: Returns a range reference that shifts a specified number of rows and columns from a starting cell reference.

Notes

  • If you set row or column to 0, INDEX returns the array of values for the entire column or row, respectively.
Was this helpful?
How can we improve it?