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
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 

EMPTY

EXTRACT

Last modified 3yr ago

Argument name	Description
table Required	Table to evaluate where the first column and row are the variables to evaluate.