TABLEVALUE
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 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'
Last modified 3yr ago