https://bugs.documentfoundation.org/show_bug.cgi?id=160711
--- Comment #5 from ady <[email protected]> --- JIC I was not clear enough (for whoever reads this ticket): * The problem in Calc 24.8 alpha ATM (vs. Excel) seems to be triggered when the "Search Criterion" argument is really _omitted_. * In Excel's XLOOKUP(), omitting the first argument in XLOOKUP() is _not_ the same as explicitly writing "" (aka empty string) as argument in the formula in Calc. * Omitting the "Search Criterion" argument is _not_ the same as using a reference to a cell that is blank empty. * In Calc 24.8 alpha ATM, omitting the "Search Criterion" argument seems to always result in (#N/A) error. * In Excel's XLOOKUP(), when omitting the "Search Criterion" argument, it performs a "blank empty cell" search in the "Search Array" area, providing the relevant result according to the whole set of arguments. Additionally: * Excel returns 0 (zero) when the _content_ of the _resulting_ cell/range ("Search Array" argument) is empty. This is _not_ related to the "Search Criterion" argument (except when the "Search Criterion" argument is omitted, as described above). This is _not_ the problem in Calc 24.8 alpha ATM. -- You are receiving this mail because: You are the assignee for the bug.
