https://bugs.documentfoundation.org/show_bug.cgi?id=130359
--- Comment #1 from Óvári <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
