Supported list types
Number list
This function returns the numeric reference value or a given text. If the key is not in the keyList, the function returns NULL
getMatchingValue(key, keyList, referenceList) #Output: number
Variant with 2 number lists.
getMatchingValue(key, keyList, referenceList) #Output: Number
Text list
This function returns the text reference value or a given text.
getMatchingValue(key, keyList, referenceList) #Output: Text
Variant with a number list.
getMatchingValue(key, keyList, referenceList) #Output: Text