The behaviour of INDEX-MATCH is erratic here in some cases it. Match returns a vector of the positions of first matches of its first argument in its second. Here is the problem -- I have a data set that is a subset of another data set.
If match_type is -1 the values in lookup_array should be in a descending order.
The match function returns the indices of the matches in the second argument for the values in the first argument. The detailed syntax can be seen below. Row_num the row number from which the value is to be fetched. Vector to which the values should be matched against.