I don't have xlookup in my excel

[Aleksandr_KirillovUK]

Hi Everyone,

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

[#2]

@Aleksandr_KirillovUK 

Could you please share your version of Excel from File->About, it looks like

[#3]

Version 2103 (Build 13901.20400 Click-to-Run)
Current Channel (Preview)

[#4]

@Aleksandr_KirillovUK 

Thank you. Looks strange. Could you please open attached file and check what it shows in formula bar. Inside is nothing but

[#5]

=_xlfn.XLOOKUP(;A:A;B:B)

[#6]

@Aleksandr_KirillovUK 

Sorry, I'm in lack of ideas of what it could be. Perhaps couple of abstract

- you are on Windows 7 (Office is not supported on it and has some limitations)

- that's very fresh installation (sometimes it takes time to switch this or that functionality ON for the subscription model)

If no one of above I'll try to ask someone else if they know. Just in case, which locale do you use?

[#7]

Thank you, I use English and I have Windows 10

[#8]

@Aleksandr_KirillovUK 

Thank you, I asked, will share if any news. In any case I'd recommend to Send a Frown from Help->Feedback.

[#9]

Ok, thank you so much

[#10]

@Sergei Baklan 

The version of my excel is 2016 ( office 2016)

[#11]

@poroa 

XLOOKUP() and lot of other new functions are not supported in 2016