https://bugs.documentfoundation.org/show_bug.cgi?id=161592
--- Comment #13 from Regina Henschel <[email protected]> --- Created attachment 194768 --> https://bugs.documentfoundation.org/attachment.cgi?id=194768&action=edit XMATCH and XLOOKUP The situation for XLOOKUP and XMATCH is worse. Not even "Recalculate Hard" gives the correct results. You need to save and reload the file. Load document. Change value in cell B2. Notice that results become #N/A. Save and reload. Now the values are correct. I have not made a new bug report because XLOOKUP and XMATCH use the same code in interpr1.cxx as MATCH and thus a common reason is likely. If a fix for MATCH does not fix XLOOKUP and XMATCH a follow up bug report can be created then. -- You are receiving this mail because: You are the assignee for the bug.
