<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - XLOOKUP() function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130359#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - XLOOKUP() function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130359">bug 130359</a> from <a class="email" href="mailto:ovari123@zoho.com" title="Óvári <ovari123@zoho.com>"> Óvári</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157593" name="attach_157593" title="Example 4">attachment 157593</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157593&action=edit" title="Example 4">[details]</a> Example 4 Example 4 --------- The following example looks in column C for the personal income entered in cell E2, and finds a matching tax rate in column B. It sets the if-not_found argument to return a 0 if nothing is found. The match_mode argument is set to 1, which means the function will look for an exact match, and if it can't find one, it will return the next larger item. Finally, the search_mode argument is set to 1, which means the function will search from the first item to the last. Note: Unlike VLOOKUP, the lookup_array column is to the right of the return_array column, where VLOOKUP can only look from left-to-right.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>