Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Arithmetic Functions

Dot Operator

Select a list of text values from a lookup table

Find a list of text values in a named column of a lookup table.
The lookup table used is the first which has both the
return column
 and a
find column
 containing all the members of the given list or which contains an empty cell. Note that the
find column
 will be different from the
return column
.
The function returns a cell text in the
return column
 for every member of the given list. If the member occurs in a cell of the
find column
 then the return text is the corresponding cell of the
return column
 for that row of the lookup table. Otherwise, it is the corresponding cell in the
return column
 for an empty cell in the
find column
.
Returns:
Text*
Parameters:
Parameter
Data Type
Description
1
Any*
The given list of texts.
2
Any
The name of the return column.
Example:
When using functions inside a field, remember the field brackets:
{ServicesIncluded.Cost}
Expression
Result
List( "England", "Japan", "USA" ).Capital
where a lookup table contains countries and their capitals
List( "London", "Tokyo", "Washington" )
List( "US of A" ).Capital
where a lookup table contains an empty cell in the countries column with the text
Unknown Capital City
 in the corresponding cell of the capitals column
List( "Unknown Capital City" )

Select a text value from a lookup table

Find a text value in a named column of a lookup table.
The lookup table used is the first which has both the
return column
 and a
find column
 containing the given text or which contains an empty cell. Note that the
find column
 will be different from the
return column
.
If the given text occurs in a cell of the
find column
 then the return text is the corresponding cell of the
return column
 for that row of the lookup table. Otherwise, it is the corresponding cell in the
return column
 for an empty cell in the
find column
.
Returns:
Text
Parameters:
Parameter
Data Type
Description
1
Any
The given text.
2
Any
The name of the return column.
Example:
When using functions inside a field, remember the field brackets:
{ClientName.Address}
Expression
Result
"England".Capital
where a lookup table contains countries and their capitals
"London"
"US of A".Capital
where a lookup table contains an empty cell in the countries column with the text
Unknown Capital City
 in the corresponding cell of the capitals column
"Unknown Capital City"

This article applies to:

  • Product: Contract Express