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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130359
           Summary: XLOOKUP() function
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ovari123 at zoho.com

Description:
Use the XLOOKUP function when you need to find things in a table or a range by
row. For example, look up the price of an automotive part by the part number,
or find an employee name based on their employee ID. With XLOOKUP, you can look
in one column for a search term, and return a result from the same row in
another column, regardless of which side the return column is on.

https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

Steps to Reproduce:
New XLOOKUP() function for LibreOffice Calc

Actual Results:
Unknown function

Expected Results:
XLOOKUP() function known and variations working


Reproducible: Always


User Profile Reset: No



Additional Info:
Examples to follow

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