FWIW, both OnlyOffice and LibreOffice support XLOOKUP. In fact LibreOffice has over 500 Excel formulae, which is very close to the number of formulae Excel has.

FWIW, both OnlyOffice and LibreOffice support XLOOKUP. In fact LibreOffice has over 500 Excel formulae, which is very close to the number of formulae Excel has. Unless you use a lot of VBA (and you can't translate it to Python), or you've got some proprietary COM addin that you can't live without, LibreOffice's Calc is a pretty damn good replacement for Excel for the majority of users.