Description
This formula retrieves a value from the column of a table attribute if it matches the value of another attribute.
Formula(s)
PHP
{=MATCHTABLEVAL(Attribute;Column;Comparative attribute;"Comparative value";Formatted;Compare formatted)}
Result
-
Array
Parameters
Parameter
|
Content
|
Format
|
Default value
|
Explanation
|
|---|---|---|---|---|
|
Attribute |
Table attribute ID or table attribute name |
Table attribute ID: Integer Table attribute name: String |
|
|
|
Column |
Column attribute ID or column attribute name |
Column attribute ID: Integer Column attribute name: String |
|
|
|
Comparative attribute |
Comparative attribute ID or comparative attribute name |
Comparative attribute ID: Integer Comparative attribute name: String |
|
|
|
Comparative value |
|
String |
|
|
|
Formatted |
TRUE or FALSE |
Boolean |
TRUE |
TRUE: Formatted FALSE: Unformatted |
|
Compare formatted |
TRUE or FALSE |
Boolean |
FALSE |
TRUE: The formatted value is used for comparison. FALSE: The unformatted value is used for comparison. |