Skip to main content
Version: Streamsheets 3.0

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

NameTypeDescription
CellRangeRangeCell range to treat like a table. Its first row and its first column are used to reference table cells.
RowIndexNumberThe row index of a table cell.
ColumnIndexNumberThe column index of a table cell

Return

TypeDescription
Number or ErrorThe value of specified table cell or an error value if cell range does not contain specified cell.

Examples

TimeTurbine1Turbine2Turbine3
93370100020003000
93360150025003500
FormulaResultComment
=TABLE.GET(A3:D5, 93370, "Turbine 1")
1000
=TABLE.GET(A3:D5, 93360, "Turbine 2")
2500