⌃K

TABLEVALUE

The TABLEVALUE function returns the cell value of a table using row and column identifiers.

Syntax
TABLEVALUE(table, rowVal, colVal)
Argument name
Description
table
Required
Table to evaluate.
rowVal
Required
Value of the first column to find the row.
colVal
Required
Value of the header to find the column.
Examples
​
TABLEVALUE(calendar, '11', 'Wed') returns 'Meting'
TABLEVALUE(calendar, '9', 'Thu') returns 'Call'

SPLIT

TRUNC

Last modified 2yr ago

Argument name	Description
table Required	Table to evaluate.
rowVal Required	Value of the first column to find the row.
colVal Required	Value of the header to find the column.