Returns the content of a cell, specified by row and column offset.
Examples
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.