Lookup and Reference Functions
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])
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.