https://bugs.documentfoundation.org/show_bug.cgi?id=153297
--- Comment #14 from Winfried Donkers <[email protected]> --- Using MATCH with 3rd argument 1, -1 or leaving 3rd argument empty (which then defaults to 1) requires the range that is searched to be sorted. If the range is not sorted , the result is not defined and can be different for different applications or even versions. Also, when the ordering is ascending, the last match is returned and when the ordering is descending, the first match is returned. See "https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1018430_715980110";. In the sample files that have been attached, none of the ranges looks sorted to me. Then all results for MATCH with 3rd argument 1, -1 or empty have no real meaning. AFAICS this is not a bug. FWIW, I am currently working on a change in the code that does the searching for MATCH, LOOKUP, HLOOKUP and VLOOKUP to handle searching for XLOOKUP as well. These changes could produce different results again. -- You are receiving this mail because: You are the assignee for the bug.
