Forum Discussion
XLOOKUP
Hello, i can't find the xlookup function in excel. I have the office 365 version and understand it should be there.
Thanks!
9 Replies
You can switch to the Monthly channel of Microsoft 365 with this guide - http://bit.ly/2G8qHhx and get XLOOKUP and also FILTER etc today. It takes just a couple of minutes.
IMHO, that could be useful if switch from one channel to another from time to time. If on permanent basis better with ODT or ask IT to switch. If we speak about corporate environment.
Thanks for the reply. I put the menu update, it was updated, but the new functions (FILTER, XLOOKUP) still do not appear. The strange thing is that despite having office 365, it appears to me that I have office 2016 Professional Plus. Maybe that's the reason.
Hi daromelman I can see it my Excel 2019
Really? When it appeared on 2019?
- Hello, go to File > Account > Click on Update Now...
It should be available if you're on Microsoft 365 Insider or Monthly Channel It shall be, but so far not on semi-annual channel. If you are on it, XLOOKUP will appear some later.
