XLOOKUP in Excel not available

Question

Hi,

I'm on the InsiderFast update in Excel, and my current version is 1910 (Build 12030.20004)

Why is XLOOKUP not available? Something I need to do? When i try to update, it says I have the latest version.

Regards

Marius Sv

Answer 1

Just wait a little longer.

MS never rolls out new features to everyone at the same time. They do "staged rollouts", one section of the world at a time. You will get it "eventually / Mañana .  Be patient.

BUT, as this article points out (at the end), these new features are limited to 365. So if you even think someone with a non-365 license is going to use the file, you CAN'T use this new command.  Thanks for increasing the confusion MS!

https://office-watch.com/2019/xlookup-is-coming-and-its-truly-a-great-thing/

Answer 2

XLOOKUP is still rolling out to all Insiders, so you may not see it quite yet. It will be available to everyone soon.

-Jesse

Answer 3

Hi,

My name is Naval and I am an Independent Advisor. I would like to help you.

XLOOKUP is available for users signed up for the Office 365 Insiders Program starting today and will continue rolling out to Insiders over the next few weeks. Gradual roll outs allow us to gather feedback and ensure feature quality.

Please read this article for reference : https://techcommunity.microsoft.com/t5/Excel-Bl...

If you are working on Office 365 Insiders Program it will surely work for you and if it is not working it could be application malfunction that need to be repair :

https://support.office.com/en-us/article/repair...

If it still not work, I suggest you to submit your feedback in user voice :

Hope this information helps. Please post if you need any further assistance.

Answer 4

Same issue here with the exact same build. After a week trying, but failing to updat, it finally worked tonight. Sadly, no XLOOKUP function.

Alan