<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Help of vlookup and hlookup: Sort order or Order are Approximate" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121090#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Help of vlookup and hlookup: Sort order or Order are Approximate" 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=146215" name="attach_146215" title="Use vlookup according ordered data or if you need approximate result.">attachment 146215</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=146215&action=edit" title="Use vlookup according ordered data or if you need approximate result.">[details]</a> Use vlookup according ordered data or if you need approximate result. The fourth parameter, what is it for? Do you inform the function about whether the list is ordered? or Ask the function to do an approximate search or not? I have uploaded a file with example. Could be that I do not understand the English, because I am spanish and so the Esperanto language is better for international communications.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>