[Libreoffice-bugs] [Bug 130359] XLOOKUP() function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130359

--- Comment #4 from Óvári <ovari123 at zoho.com> ---
Created attachment 157593
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157593&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200202/9c39d7cb/attachment-0001.htm>