Platform - Feature #6566 (Feedback): Implemented MatchFormulaFunction
Excel's "=MATCH" function has been implemented.
Excel's version requires values sorted in an ascending order for match_type 1, and a descending order for match_type -1. If a range isn't sorted, the MATCH function will return a value which does not meet the criteria of the MATCH arguments, yet does not provide an error message to show that this evaluation didn't properly find the right value.
What I have done is "fix" the MATCH function to always give a #N/A error if a proper value is not found. This means that if match_type is given as 1 (or not provided, which defaults to 1) then the lookup_array must be in an ascending order. If it is not, then a #N/A error is provided. The same is true for match_type -1 and a descending order.