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