This function returns a value or the reference to a value from within an array or range.
INDEX(return,row,col,area)
The arguments are as follows, and are truncated if not integers:
| Argument | Description |
|---|---|
| return | Returns a value or a reference of a cell or range of cells |
| row | Row number in the range |
| col | Column number in the range |
| area | [If return is a cell range reference] Area of the range |
Accepts numeric data. Returns numeric data.
INDEX(A2:C3,2,2)
INDEX(R2C1:R3C3,5,3)