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