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)}Result
Array
Parameters
Parameter | Content | Format | Default value | Explanation |
|---|---|---|---|---|
Attribut | Tabellenattributname oder Tabellenattribut-ID | Tabellenattributname: String Tabellenattribut-ID: Integer |
|
|
Attribute | Table attribute name or table attribute ID | Table attribute name: String Table attribute ID: Integer |
|
|
Column | Column attribute name or column attribute ID | Column attribute name: String Column attribute ID: Integer |
|
|
Comparative attribute | Comparative attribute name or comparative attribute ID | Comparative attribute name: String Comparative attribute ID: Integer |
|
|
Comparative value |
| String |
|
|