INDEX¶

Returns a cell within the range using the row and column offset.

Syntax

=INDEX(Range,Row,Column)

Arguments

Name Description
Range Range of cells to search in.
Row Row index or offset starting with 1.
Column Column index offset starting with 1.

Return Value

Cell value of the cell within the range with an offset of row and column.

Example

Function Result Comment
=INDEX(A2:B4, 2, 1)

INDEX
8 The value of cell A2 is returned.