Bug 127293 - Add XLOOKUP function in Calc
Summary: Add XLOOKUP function in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha1+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 130359 (view as bug list)
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2019-09-02 14:46 UTC by Roman Kuznetsov
Modified: 2020-06-07 07:50 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2019-09-02 14:46:21 UTC 
Description:
Add XLOOKUP function in Calc

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

Steps to Reproduce:
-

Actual Results:
-

Expected Results:
-


Reproducible: Always


User Profile Reset: No



Additional Info:
-
Comment 1 Mike Kaganski 2019-10-28 07:53:21 UTC 
See also accompanying XMATCH: https://support.office.com/en-us/article/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312
Comment 2 Julien Nabet 2020-02-02 08:26:27 UTC 
*** Bug 130359 has been marked as a duplicate of this bug. ***
Comment 3 gmolleda 2020-02-26 12:19:43 UTC 
Explained function in Spanish: https://ayudaexcel.com/por-que-la-funcion-buscarx-esta-revolucionando-las-busquedas/