https://bugs.documentfoundation.org/show_bug.cgi?id=163821
--- Comment #2 from Jürgen Kirsten <[email protected]> --- Sorry ich habe mich verschrieben: Richtig lautet die Beschreibung: Description: If you enter the formula: =XLOOKUP("A",{"A"; "B"},{1;2},"") in Calc, you will not get the expected result 1 but the content from cell A1 of the first worksheet. XLOOKUP works if you have stored the search array and result array in cells somewhere in the worksheet and refer to it. Steps to Reproduce: 1. write "Hello world" in cell A1 2. write the formula =XLOOKUP("A",{"A"; "B"},{1;2},"") in any other cell in the worksheet Actual Results: "Hello world" Expected Results: 1 Reproducible: Always User Profile Reset: Yes Additional Info: With =XLOOKUP("B",{"A"; "B"},{1;2},"") you get the result of cell B1. To see changes you must recalculate Hard. In Microsoft Excel you get the correct result 1. -- You are receiving this mail because: You are the assignee for the bug.
