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)
Argument name
Description
table
Required
Table to evaluate where the first column and row are the variables to evaluate.
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