Release XLOOKUP to the world!
Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!
I guess I'm a curmudgeon, then, and will keep using INDEX+MATCH instead of VLookup, or even the new XLookup function, if I could.
Really disappointed in trying to be prodded into using Office 365 this way..
Even more disappointed in seeing that other features (I'm looking at Visio's new data-bound templates) require a particular $ option for O365 to use. At least the old school way of doing it manually still works.
Oh, on the flip side, Visio 2019 still does MDI...
I paid for Office 2019 Pro full license desktop version because that is what I need. Why is MS excluding people like me from the latest updates just because we are not on O365? I paid for a full genuine MS license and should get the updates.
Jitendra bhatt commented
Please provide xlookup and dynamic array function to Office 2019 other users. That helps to increase our productivity much more
please provide xlookup feature as soon as possible to office 2019 and other offline users. thats helps lot to us.
Please release this to the world ! XLOOKUP AND XMATCH
I've updated the Excel-DNA XFunctions add-in which provides these two functions to all Excel versions. The [if_no_match] parameter is now present in the XLOOKUP, so the replacement XLOOKUP and XMATCH should match (!) the Office 365 versions exactly.
The add-in is freely available here: https://github.com/Excel-DNA/XFunctions/releases.
Microsoft 365 Apps for enterprise
Whiteboard (Plan 2)
Microsoft Forms (Plan E1)
OneDrive for Business (Plan 1)
The latest desktop version of Office, in this version of excel is not available XLookup, what should I do to enable it?
Excel for Office 365 MSO (16.11929.20836) 64 bits, this version of excel is not available XLookup, what should I do to enable it?
I HAVE HOME OFFICE & STUDENT 2019. I WOULD LOVE TO UPDATE IT TO INCLUDE XLOOKUP AND XMATCH. WHY AM I NOT ALLOWED TO DO SO.
Please Microsoft get these functions added to Excel 2019
Jim Davis commented
Please add XLookup and XMatch to Excel 2019
S. Stockton commented
Look for the Excel-DNA XFunctions Add-in. It's on GitHub, giving you XLOOKUP and XMATCH. Last I checked, it's syntax matches previous syntax from Microsoft's beta testing period The Excel blog article 811376 has the current syntax, and a request to update the XFunctions add-in to match the latest syntax already exists (just need somebody to submit a patch on GitHub).
Miguel Armas commented
Please add XMATCH and xlookup, to office 2019
PLEASE add xlookup to Excel 2019!!!! I use it at home and desperately need it at the office and they have Excel 2019.
This has so many great reviews - please make it available for all Excel users
Please - I need this! :)
TLC in Austin commented
xLookup is the total bomb. Best thing to happen in Excel since forever !!!!!
The XLookup and XMatch is a long awaited feature for this user (20+ years). VLookup is great and I have used it a lot, but it's cumbersome for quick lookup needs.
Yes please, introduce it to excel 2019 desktop
Ed Hekman commented
yes please! Why introduce a function that forces all users to either upgrade (the ones that do not get it) or to ignore (the ones that want compatibility)?