Can't find XLOOKUP

[Mahmudcma]

Hi Everyone,

I have been using Office 365 and also joined in insider. But unfortunately cant find XLOOKUP function inside.

Looking forward your suggestion.

Thanking you 

Mahmud

[#2]

@Mahmudcma 

Please check your version of Excel in File->Account. If it's like

If Office Insider and version as above or close to it, you shall have XLOOKUP. Send the frown to Microsoft then. If not, update your Office.

[#3]

@Sergei Baklan 

Thank you so much for your reply. Yes I do have the same version of excel. but still I cant find it. 

[#4 · Accepted solution]

@Mahmudcma 

Strange, I was sure it's now for all Insiders Fast. When it's question to Microsoft. Options are

- find blog in this community where XLOOKUP was announced and ask you question in comments directly mentioning the author of the blog;

- Send a Frown from File->Feedback

[#5]

Thanks a lot !!
Just tried again and I found the function.

[#6]

@Mahmudcma , great, thank you for the update.

[#7]

@Sergei Baklan 

My excel version is the below 

and I cannot use xlookup in my excel.

do you have any suggestion how to use it?

[#8]

@cricol 

It's not available for semi-annual channel, perhaps this fall. You may shift on Monthly channel.

[#9]

I will check if my company allow that.

[#10]

@Sergei Baklan I have the same problem.
My Excel version is the below

[#11]

@abrahaodcs 

Do I understand correctly you don't have XLOOKUP() on English 365, current version on Beta channel? That's unbelievable, it has to be. Perhaps problems could be with Windows 7, but even in this case I doubt.

That's only to Send a Frown from Help->Feedback or open support ticket.