Only Excel for Office 365 will get the new XLOOKUP function. Excel 2019 and all previous versions won’t ever get this new function. XLOOKUP is currently only available to those enrolled in the Office Insidersprogram. But it will eventually become generally available to all Office 365 users.
Another frequent query is “What is XLOOKUP in Excel 2007?”.
XLOOKUP is a new flavored lookup function provided in OFFICE 365. XLOOKUP is very much advanced and versatile when compared with the previous versions of lookup functions like V LOOKUP, HLOOKUP or INDEX-MATCH etc. XLOOKUP lets us lookup in any column in the table whether it is to.
Is XLOOKUP available for Office 365?
Xlookup now available for all Excel 365 platforms 12 February 2020 Xlookup is now available across all the Excel programs and apps, making it a viable alternative to Vlookup/Hlookup for Office 365 users. The Xlookup function is the much-improved way to lookup values from a list or table.
Does excel XLOOKUP work well on a single computer?
It works really well but it’s taken some time to appear across all incarnations of Excel 365 and for all users, not just fast-track Insiders. That meant Xlookup was OK for solo use on a single computer but could be a compatibility problem if the workbook was shared to other devices or people.
A common query we ran across in our research was “Can XLOOKUP workbooks be shared with other devices?”.
Now Xlookup workbooks can be shared with any device using Excel 365 : The function is NOT available on any other version of Excel, including Excel 2019. Check out our explanation of Xlookup including all the very useful improvements.
Is there an alternative to VLOOKUP in Excel?
Xlookup is now available across all the Excel programs and apps, making it a viable alternative to Vlookup/Hlookup for Office 365 users. The Xlookup function is the much-improved way to lookup values from a list or table.