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 shifted 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.