Skip to main content
Version: Streamsheets 2.4

INDEX

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

Syntax

=INDEX(Range,Row,Column)

Arguments

NameDescription
RangeRange of cells to search in.
RowRow index or offset starting with 1.
ColumnColumn index offset starting with 1.

Return Value

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

Example

FunctionResultComment
=INDEX(A2:B4,2,1)
8The value of cell A2 is returned.