XLOOKUP was implemented last year. Submit a bug report with an example document and the perf issue can be looked into. Calc's performance is being improved constantly.

https://wiki.documentfoundation.org/QA/BugReport