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

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

Examples

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