https://bugs.documentfoundation.org/show_bug.cgi?id=159467
--- Comment #6 from Balázs Varga (allotropia) <[email protected]> --- Thanks for the explanation and investigation Ady. :) =XLOOKUP(A12;A2:A8;B2:B8;XLOOKUP(A12;F2:F8;G2:G8;0)) The reason why it is work and the original ones not, because in the above function the inner function give back not an error msg (like #N/A) but a 0 value if the searched value not found. In that case the evaluation of the full formula will not stop after the evaluation of the inner function. --> After evaluation of the embedded XLOOKUP this is the result: =XLOOKUP(A12;A2:A8;B2:B8;0) In case of the original case the result was: =XLOOKUP(A12;A2:A8;B2:B8;#N/A) -> #N/A which is an error type. In Calc if an inner, embedded function gives back an error (like #N/A) the evaluation of the full formula will stop after the inner function. This is the basic work of the functions in Calc and also in Excel. But the XLOOKUP is an exception in excel. :) -- You are receiving this mail because: You are the assignee for the bug.
