Stringfunctions+ | Formula MATCHTABLEVAL
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. |