Release XLOOKUP to the world!
Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!
My company won't move to Office 365, we are still on Office 2016. These formulas should be released as an update for all supported versions.
I had a similar problem. I tried unistall/reinstall many times. It was related the user profile. I created a new user profile on the PC and, even using the same O365 login, the X functions were working. Log on to your machine with a different/new user profile and see if this works.
The issue is still not fixed, I have just abandoned the old user profile.
I have been uninstall and install office several times without and with office 365 support team, because all new dynamic array functions and also xlookup functions just vanish from my desktop while ago (version build 12527.20278.) Could you please provide some support portal address or explanation why those just features vanish without reason and where I can get support after your own office 365 support team had to raise hands up because they could not fix the problem.
Please release to everyone.
XLookup is not working on version 2002 Build 12527.20278
But working on 2003 Build 20224.
I'm on the first release targeted channel monthly and still not getting the update.
Samantha Barber commented
Please add XLOOKUP to Excel 2019!
Please release Xlookup, Filter, Sequence and Xmatch for 2019 and earlier users.
Please release lookup in Excel 2016 windows
Please release xlookup and xmatch in 2019 version.
AKASH BHAYANI commented
i used Xlookup in office 365 its amazing and make my work more simpler... please release it in Excel 2019 also as soon as possible.
Steven 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 ...!!!