The EVALTABLE function evaluates a table where the first column and row are the variables to evaluate, returning the first matching cell found.
Table to evaluate where the first column and row are the variables to evaluate.
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