Supported list types
Number list
This function returns the numeric reference value
getMatchingValue(key, keyList, referenceList) #Output: number
Variant with 2 number lists.
getMatchingValue(key, keyList, referenceList) #Output: Number
Text list
This function returns a text value in value_list that is in the same position as text key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list then, the element of value_list in position count(key_list) + 1
.
getMatchingValue(text key, textList key_list, textList value_list) #Output: Text
Variant where argument key is a number and argument key_list is a number list.
getMatchingValue(number key, numberList key_list, textList value_list) #Output: Text