https://bugs.documentfoundation.org/show_bug.cgi?id=160711
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #3 from ady <[email protected]> --- In XLOOKUP(), the argument named "Lookup" (aka "lookup_value" in Excel) is required, but if it is omitted then XLOOKUP() should return blank cells it finds in the "Array" area (aka "lookup_array" in Excel). Currently in Calc 24.8 alpha, this seems to be not true, so the search fails to find a match and thus the #N/A result is given. For the sample in this report, the first blank cell would return "itself", and Excel's XLOOKUP() returns 0 (zero) for blank (empty) results. In Excel, this is not the same as not finding a match. IIRC, also Google Sheets fails to comply with this condition, but I could be misremembering. @Regina, BTW, IINM, that build you posted in comment 0 lacks the latest modifications to XLOOKUP (adding regex support). It should not alter your result regarding XLOOKUP() for this case anyway. Please also keep in mind that other functions such as CELL() have their own bugs. I hope we are focusing on XLOOKUP() in this report. -- You are receiving this mail because: You are the assignee for the bug.
