<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Error with new function recherchev (in french)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132131#c28">Comment # 28</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Error with new function recherchev (in french)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132131">bug 132131</a> from <a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> Julien Nabet</a> <pre>No bug here, it's described in <a href="https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152">https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152</a> " If the Sorted parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact SearchCriterion is not found, the last value that is smaller than the criterion will be returned. " So in your case, sort your data on G column (since it's the key search), then put 0 for last argument. For the rest, indeed it's different from Excel since the last argument hasn't the same meaning.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>