https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 160725, which changed state.
Bug 160725 Summary: XLOOKUP has different result for approximate search than Excel https://bugs.documentfoundation.org/show_bug.cgi?id=160725 What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.