Why XLOOKUP only works in version 365?

Occasional Visitor

Hey, can any microsoft engineers open up the xlookup access for other Microsoft version as well? I got only 1 desktop with Microsoft 365, Xlookup only works in 365 version. My laptop is using 2016, that's really inconvenient to switch to one another everytime I need to use xlookup...

1 Reply

@beehuan 

I'm not Microsoft, but I can tell you that they won't add functions such as XLOOKUP to previous versions, not even to the current Excel 2019. The new functions will only be available in Excel in Office 365 and probably in the next version (Excel 2022?).