Skip to main content
Version: Streamsheets 2.3

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

NameDescription
CellRangeCell range to treat like a table. Its first row and its first column are used to reference table cells.
RowIndexThe row index of a table cell.
ColumnIndexThe 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

TimeTurbine 1Turbine 2Turbine 3
93370100020003000
93360150025003500
FunctionResultDescription
=TABLE.GET(A3:D5, 93370, "Turbine 1")1000Gets the value from table cell (93360, "Turbine 1") which is 1000
=TABLE.GET(A3:D5, 93360, "Turbine 2")2500Gets the value from table cell (93360, "Turbine 1") which is 2500