May 17 2020 09:05 AM
Hello, i can't find the xlookup function in excel. I have the office 365 version and understand it should be there.
Thanks!
May 17 2020 09:32 AM
It shall be, but so far not on semi-annual channel. If you are on it, XLOOKUP will appear some later.
May 17 2020 09:34 AM - edited May 17 2020 09:36 AM
May 17 2020 11:41 AM
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.
May 17 2020 11:49 AM
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.
May 17 2020 11:58 AM
Absolutely. This is assuming people have the admin rights to change it - as you say in a corporate setting this may not be possible, or wise to.
May 17 2020 02:46 PM
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.
May 18 2020 12:17 AM