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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Óvári <ovari123 at zoho.com> ---
Created attachment 157590
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157590&action=edit
Example 1

Example 1
---------

This example uses a simple XLOOKUP to look up a country name, then return its
telephone country code. It only includes the lookup_value (cell F2),
lookup_array (range B2:B11), and return_array (range D2:D11) arguments. It does
not include the match_mode argument, as XLOOKUP defaults to an exact match.

Note: XLOOKUP is different from VLOOKUP in that it uses separate lookup and
return arrays, where VLOOKUP uses a single table array followed by a column
index number. The equivalent VLOOKUP formula in this case would be:
=VLOOKUP(F2,B2:D11,3,FALSE)

-- 
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/d6ce98fc/attachment.htm>