|
<< Click to Display Table of Contents >> INDEX (cell in a particular row/column of a range) |
Syntax:
INDEX(Range, Row, Column [, PartRange])
Description:
This returns a reference to the cell at the intersection of the specified Row and Column of the Range.
The desired cell range is to be specified for Range.
You use Row and Column to determine the row and column of the Range in which the cell to be returned is located (starting from the top left corner of the Range).
If Row or Column refers to a cell outside the range, a #REF! error value is returned.
The optional argument PartRange is just a placeholder (for compatibility with Microsoft Excel). It can be specified, but PlanMaker will not evaluate it.
Compatibility notes:
This function is not fully compatible with the Excel function of the same name. The following restrictions apply:
The argument Range does not support multiple selections (nonadjacent ranges).
The argument PartRange is not evaluated.
Example:
INDEX(B2:D4, 2, 2) returns a reference to cell C3
See also: