https://bugs.documentfoundation.org/show_bug.cgi?id=144770
--- Comment #3 from Eike Rathke <[email protected]> --- Why do you think this is supposed to work? Unlike the similar construct with LOOKUP(2;1/...) (which is a special case), MATCH() for an array passed does not ignore error values nor does it magically sort the array, so with {~DIV/0!;~DIV/0!;~DIV/0!;~DIV/0!;1;~DIV/0!;~DIV/0!} a range search, as the third argument is not given the data MUST be strictly sorted ascending, in such unsorted array may yield arbitrary results. The cited help text "This applies even when the search array is not sorted" is simply wrong. I don't know where the author got that idea from. -- You are receiving this mail because: You are the assignee for the bug.
