https://bugs.documentfoundation.org/show_bug.cgi?id=159467
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #4 from ady <[email protected]> --- XLOOKUP still failing after (second) patch from tdf#127293 comment 44, dated 2024-02-09, using Calc dated 2024-02-11 Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 17fc445938dedb05125a6d6a5b4ce7f34ea95f59 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: threaded I have also tested with 2 other spreadsheet tools and using STR from comment 0 works correctly there, but generates #N/A (not available error) in LO Calc. In Calc, attachment 192274 > worksheet "Ex5" > when the search string (cell A12) is found in the list in range A2:A8, for the chained XLOOKUP to provide the "correct" result (although, only by chance), the same string has to be also part of the other list in range F2:F8 too. If the search string is not part of the second range F2:F8 too, then the result is #N/A. Or, IOW, the formula appears to be able to retrieve _the result_ from both lists (B2:B8; G2:G8), but it is searching the criterion only on the second range F2:F8. Translated to the array formula: =XLOOKUP(A12;A2:A8;B2:B8;XLOOKUP(A12;F2:F8;G2:G8)) ... it is only executing the search of the criterion on the second XLOOKUP(), which is the "Result_if_not_found" of the first XLOOKUP(), but it can retrieve the result from the first XLOOKUP() (too). -- You are receiving this mail because: You are the assignee for the bug.
