|
<< Click to Display Table of Contents >> INDEX (cell in a particular row/column of a range) |
Syntax:
INDEX(Range, Row, Column [, PartRange])
Description:
Returns a reference to the cell at the intersection of the specified Row and Column in Range.
Range is the cell range from which to return a reference.
Row is the relative number of the row in Range and Column is the relative number of the column in Range (starting from the upper left corner of Range).
If Row or Column refers to a cell outside Range, a #REF! error value is returned.
The optional argument PartRange is just a placeholder (for compatibility with Microsoft Excel). It will not be evaluated.
Compatibility notes:
This function is not fully identical to Microsoft Excel's INDEX function. The following restrictions apply:
The argument Range must consist of exactly one contiguous cell range. Nonadjacent ranges are not supported.
The optional argument PartRange is ignored.
Example:
INDEX(B2:D4, 2, 2) returns a reference to cell C3
See also: