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 | Description |
|---|---|
| CellRange | Cell range to treat like a table. Its first row and its first column are used to reference table cells. |
| RowIndex | The row index of a table cell. |
| ColumnIndex | The column index of a table cell |
Return
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 |