Match

0

MATCH (lookup_value, lookup_array, match_type)

The MATCH function will return the absolute position of a specified lookup value, within a given range (array).
The “lookup_value” is the specified value that the function will lookup within the range. The “lookup_array” is the range that the function locate the lookup value. The “match_type” is irrelevant in Xcelsius since the model will always bring back the absolute position of the first found instance of the lookup value. For this you can always enter a 0 or FALSE.

Share.

Leave A Reply