TABLE.GET
Gets the value from the table cell at specified index. To create a table like cell range please refer to TABLE.UPDATE.
Syntax
=TABLE.GET(CellRange, RowIndex, ColumnIndex)
Arguments
| Name | Type | Description |
|---|---|---|
| CellRange | Range | Cell range to treat like a table. Its first row and its first column are used to reference table cells. |
| RowIndex | Number | The row index of a table cell. |
| ColumnIndex | Number | The column index of a table cell |
Return
| Type | Description |
|---|---|
| Number or Error | The value of specified table cell or an error value if cell range does not contain specified cell. |
Examples
| Time | Turbine1 | Turbine2 | Turbine3 |
|---|---|---|---|
| 93370 | 1000 | 2000 | 3000 |
| 93360 | 1500 | 2500 | 3500 |
| Formula | Result | Comment |
|---|---|---|
| 1000 | |
| 2500 |