Edit me

Lookup and Reference Functions

CHOOSE

The CHOOSE function returns one of the values provided in its arguments based on the number in the first argument.

CHOOSE (index_num, value1, [value2, …, valueN])

MXLOOKUP

The MXLOOKUP function is used to lookup values in design tables.

MXLOOKUP (value, table, lookup_column, return_column)

Value is a string or numeric value denoting which value to lookup

Table is a string value depicting the table code

Lookup_column is a string value depicting column name in which value is to be looked up

Return_column in a string value depicting column name whose value is to be returned in the matching row.