The TABLEVALUE function returns the cell value of a table using row and column identifiers.
TABLEVALUE(table, rowVal, colVal)
Argument name
Description
table
Required
Table to evaluate.
rowVal
Value of the first column to find the row.
colVal
Value of the header to find the column.
TABLEVALUE(calendar, '11', 'Wed') returns 'Meting'
TABLEVALUE(calendar, '9', 'Thu') returns 'Call'
Last updated 5 years ago