<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#c12">Comment # 12</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>Taking a look at <a href="https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx?r=61d8db6b#7204">https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx?r=61d8db6b#7204</a> 7204 void ScInterpreter::CalculateLookup(bool bHLookup) 7205 { ... 7210 // Optional 4th argument to declare whether or not the range is sorted. 7211 bool bSorted = true; 7212 if (nParamCount == 4) 7213 bSorted = GetBool(); 7214 ... 7299 if ( bSorted ) 7300 rEntry.eOp = SC_LESS_EQUAL; So when there's no final ";", it's considered as true. so VLOOKUP($A$2;$C$2:$E$5;2) is equivalent to VLOOKUP($A$2;$C$2:$E$5;2;1) VLOOKUP($A$2;$C$2:$E$5;) is equivalent to VLOOKUP($A$2;$C$2:$E$5;2;false) About difference with numbers, I think it's the same behaviour, if you put this in C10:D11 2 test2 1 test1 then =VLOOKUP(1;C10:D11;2) you got "N/A"</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>