https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #15 from ady <[email protected]> --- (In reply to Regina Henschel from comment #14) > Created attachment 194802 [details] > XLOOKUP created in Excel 365 > > (In reply to ady from comment #13) > > I don't have access to Excel 2021 in order to create a sample case anew > > (from scratch) with Excel itself only (and without relying on Calc at all). > > @Regina? @Miguel? > > The attached file is created in Excel 365, (Version 2405 Build > 16.0.17628.20006) Thank you. I modified the file in Calc in order to focus on the problems described in this bug report. Unfortunately, between the limitations when using binary search – there should be some kind of info/error message, somewhere – the potential issues with hard recalculate, and the differences between Excel and Calc (which I cannot test by myself), I cannot provide a trustworthy report. I am leaving this for others to figure out. -- You are receiving this mail because: You are the assignee for the bug.
