https://bugs.documentfoundation.org/show_bug.cgi?id=161727
--- Comment #4 from ady <[email protected]> --- (In reply to Stéphane Guillou (stragu) from comment #3) > Just like in bug 153297, isn't the issue that the search vector, column G, > is not sorted? Not exactly the same, but close. The third argument in MATCH() might require some sorting of the data, but LOOKUP() does not have such argument. BUT, quoting the Help for LOOKUP: "the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results." In Excel the documentation is slightly different. It says that the sorting requirement applies to the array form of LOOKUP(), but says nothing about the vector form. And indeed, the results in Excel seem to be as they were in older LO versions. Whether those results are not really meaningful (i.e. just happens to throw some result according to whichever the algorithm finds), IDK. -- You are receiving this mail because: You are the assignee for the bug.
