TABLEVALUE
The TABLEVALUE function returns the cell value of a table using row and column identifiers.
Last updated
The TABLEVALUE function returns the cell value of a table using row and column identifiers.
Last updated
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.
TABLEVALUE(calendar, '11', 'Wed') returns 'Meting'
TABLEVALUE(calendar, '9', 'Thu') returns 'Call'