Add XLOOKUP function in Calc
Steps to Reproduce:
User Profile Reset: No
See also accompanying XMATCH: https://support.office.com/en-us/article/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312
*** Bug 130359 has been marked as a duplicate of this bug. ***
Explained function in Spanish: https://ayudaexcel.com/por-que-la-funcion-buscarx-esta-revolucionando-las-busquedas/
XLOOKUP is a great enhancement over VLOOKUP. Would love to see it in Calc.
Another detailed description: https://www.excel-university.com/xlookup/
Microsoft even recommends to use the new XLOOKUP function:
> Try using the new XLOOKUP function, an improved version of VLOOKUP that
> works in any direction and returns exact matches by default, making it
> easier and more convenient to use than its predecessor.
Since this is an enhancement, please keep version as unspecified.
Would be nice to see XLOOKUP quickly in calc. We got Excel files from partners with this function and is it not usable on our side. 7.3? 7.4?
We are also looking to make the transition to LibreOffice, but can't do so because some documents we work with use the XLOOKUP feature. Other office suites have already added XLOOKUP to their functions list, so it would be great to see it in LibreOffice.
I'll have a go at it.