Release XLOOKUP to the world!
Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!
XLOOKUP is now available to all users of modern Excel across all endpoints. We deployed XLOOKUP to the last group of users (Semi-Annual channel) in July 2020.
XLOOKUP will not be available in Excel 2019 and Excel 2016. These are point in time versions of Excel that predate the release of XLOOKUP.
[Joe McDaid – Excel PM]
S. Stockton commented
Excel-DNA on GitHub has a free open-source addin that can be loaded in other Excel versions. However, Microsoft has changed the x-something functions after the 2019-10-28 update of the addin.
1) Yes, please, but 2) Don't sacrifice the backwards-compatibility that is your strength over competitors in this realm. I work in VBA, but the people for whom I code said VBA have been desperate for this feature, as it has the chance to fix some performance issues in our larger workbooks.
I have office 365 and can utilize xlookup and xmatch...great tool. However, many of the customers that I create for have Office 2013, 2016, and 2019 and are not enrolled in Office Insider.
Therefore, they cannot use my worksheets that have xlookup and xmatch in them. That means that I have to develop product for them using OLD technology.
That is bad for me and bad for them and puts Microsoft in bad light because everyone believes that it COULD be made available in previous versions (especially 2016 & 2019) which users have paid for with expectations that comparability with new features such as xlookup and xmatch would be available. I think that the excel platform/engine did not have to be completely redesigned to make xlookup and xmatch work only in office 365.
Users view the unavailability in more recent previous releases of excel as a marketing ploy by Microsoft to move to only Office 365.
Microsoft...please make xlookup and xmatch available at least in the more recent releases of excel...Thank you.
Excel Gazi Deniz Hoca commented
Yes please. TEXTJOIN(), XLOOKUP() and XMATCH() would be the only explicit reasons for asking from my employer the purchase of Excel 2019 site licenses and its organization-wide deployment.
I did an update and now have Xlookup and Xmatch on Office 2019
Give me xlookup!
I like the sound of this function, more useful than vlookup - let's all have to work with
William peter commented
Please release xlookup in 2019 version. needfully funtion
George E Brown commented
Xlookup would eradicate vlookup hlookup index and match making Excel slimmer
I'm a poor student and bought a brand new Office 2019 to get the most powerful applications on my laptop. Sad if the Excel of the user community who really knows how to use all the functionality of Excel will not benefit from technical innovations.
Office 365 is more used in companies and enterprises, often by poorly-trained users who rarely use more than 10% of the Excel functions. If that community gets an innovation it will not even realize it. They are already overloaded with what they have.
So please would you roll the new functions to the users who really need it ?
All new X functions and all new Dynamic Array Functions do deserve to be distributed to the largest possible user base ...!!!
Hope Microsoft ' decision makers ' do realize Google Sheets is gaining market share ( and mind share ) thanks to some highly powerful functions ...
My wish for 2020 : To get an Excel 2019 upgrade with all these latest great functions ...!!!
Ed Hansberry commented
XLOOKUP is now available to Insiders and Monthly Targeted users. Not sure when it will hit Monthly (hopefully soon), and I am sure Deferred/Semi-Annual is another 6 months out, as always. They are still testing which is why it isn't fully out in Office 365.
Mike Galloway commented
I am an office 365 subscriber and can't utilize xlookup or xmatch...what am I doing wrong?
Agreed! Looks great and should be accessible through desktop Excel.
I have Office 2016 and 2019 and Would love to have the functionality in both of these versions!!
Excel 2016 user here that would love to be able to use XLOOKUP!
Please get this out into the wild. multiple vlookups and index and match are a major pain.
Taylor M commented
Microsoft... please... PLEASE, release XLOOKUP.... please?
Joe Bloggs commented
and still we wait. Why Microsoft, why?
I strongly recommend releasing the Xlookup function availability to all users as its going to be a revolutionary move for Microsoft.