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