<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Change name (description) of 4th argument to VLOOKUP and HLOOKUP to "Sorted range lookup" in help and in function wizard (see comment 7, comment 9)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121090#c19">Comment # 19</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Change name (description) of 4th argument to VLOOKUP and HLOOKUP to "Sorted range lookup" in help and in function wizard (see comment 7, comment 9)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121090">bug 121090</a> from <a class="email" href="mailto:gmolleda@us.es" title="gmolleda@us.es">gmolleda@us.es</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=146252" name="attach_146252" title="Screenshot with the help inline of the 4th parameter.">attachment 146252</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=146252&action=edit" title="Screenshot with the help inline of the 4th parameter.">[details]</a> Screenshot with the help inline of the 4th parameter. When you write in the cell the function "vlookup", a littel inline help appears with the follow text: "Search criterion; Array; Index; >> Sort order): If the value is TRUE or not given, the search column of the array must be sorted inascending order." You can view that this help says nothing about if the 4th parameter is for search in intervals or exact value.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>