EVALTABLE
The EVALTABLE function evaluates a table where the first column and row are the variables to evaluate, returning the first matching cell found.
EVALTABLE(table)
Argument name | Description |
table Required | Table to evaluate where the first column and row are the variables to evaluate. |

mytable
EVALTABLE(mytable) Evaluates the table named mytable:
- If y is true and b is true then it will return 2
- If z is true and a is true then it will return 7
Last modified 3yr ago