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 Value
The value of specified table cell or an error value if cell range does not contain specified cell.
Example Below examples assumes following cells in range A3:D5
Time | Turbine 1 | Turbine 2 | Turbine 3 |
93370 | 1000 | 2000 | 3000 |
93360 | 1500 | 2500 | 3500 |
Function | Result | Description |
---|---|---|
=TABLE.GET(A3:D5, 93370, "Turbine 1") | 1000 | Gets the value from table cell (93360, "Turbine 1") which is 1000 |
=TABLE.GET(A3:D5, 93360, "Turbine 2") | 2500 | Gets the value from table cell (93360, "Turbine 1") which is 2500 |