Supported list types
Number list
This function returns the numeric value in value_list that is in the same position as string 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 is in position count(key_list) + 1
.
getMatchingValue(string key, string list key_list, number list value_list) #Output: number
This function returns a NUMBER representing the numeric value in value_list that is in the same position as numeric 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 is in position count(key_list) + 1
.
getMatchingValue(string key, number list key_list, number list value_list) #Output: Number
The function returns a NUMBER representing the numeric value in value_list that is in the same position as numeric 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(string key, number list key_list, number list value_list) #Output: Number
Text list
The 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, string list key_list, text list value_list)#Output: Text
The function returns a TEXT value in value_list that is in the same position as the numeric 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(number key, number list key_list, string list value_list) #Output: Text