<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - XLOOKUP() function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130359#c5">Comment # 5</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 <span class="vcard"><a class="email" href="mailto:ovari123@zoho.com" title="Óvári <ovari123@zoho.com>"> <span class="fn">Óvári</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=157594" name="attach_157594" title="Example 5">attachment 157594</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157594&action=edit" title="Example 5">[details]</a></span>
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))</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>