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

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

Example 5
---------

Next, we'll use a nested XLOOKUP function to perform both a vertical and
horizontal match. In this case, it will first look for Gross Profit in column
B, then look for Qtr1 in the top row of the table (range C5:F5), and return the
value at the intersection of the two. This is similar to using the INDEX and
MATCH functions in conjunction. You can also use XLOOKUP to replace the HLOOKUP
function.

The formula in cells D3:F3 is:
=XLOOKUP(D2,$B6:$B17,XLOOKUP($C3,$C5:$G5,$C6:$G17))

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