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