Apr 16 2021 03:40 AM
Hi Everyone,
I have been using Office 365 and also joined in insider. But unfortunately cant find XLOOKUP function inside
Apr 16 2021 04:14 AM
Apr 16 2021 04:26 AM
Apr 16 2021 04:32 AM
Thank you. Looks strange. Could you please open attached file and check what it shows in formula bar. Inside is nothing but
Apr 16 2021 04:54 AM
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?
Apr 16 2021 04:56 AM
Apr 16 2021 05:08 AM
Thank you, I asked, will share if any news. In any case I'd recommend to Send a Frown from Help->Feedback.
Jan 24 2023 03:33 AM
The version of my excel is 2016 ( office 2016)
Jan 24 2023 07:42 AM
XLOOKUP() and lot of other new functions are not supported in 2016