I don't have xlookup in my excel

Occasional Contributor

Hi Everyone,

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

8 Replies

@Aleksandr_KirillovUK 

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

image.png

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

@Aleksandr_KirillovUK 

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

image.png

 

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

@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?

Thank you, I use English and I have Windows 10

@Aleksandr_KirillovUK 

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

Ok, thank you so much