INDEX
Returns the value of a cell in a range specified by a row and column number.
| Category | Lookup |
| Syntax | INDEX(array, row_num, [col_num]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
array | Required | The range or array of cells. |
row_num | Required | The row number in the array from which to return a value. |
col_num | Optional | The column number in the array from which to return a value. Defaults to 1. |
Example
INDEX(value, range, col)
Auto-generated from the EngCanvas function registry.