Forum Discussion

Copper Contributor

May 17, 2020

XLOOKUP

Hello, i can't find the xlookup function in excel. I have the office 365 version and understand it should be there. Thanks!

excel

office 365

Alan_Murray

MVP

May 17, 2020

daromelman

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.

SergeiBaklan

Diamond Contributor

May 17, 2020

Alan_Murray

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.

daromelman
Copper Contributor
May 17, 2020
SergeiBaklan

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.
- SergeiBaklan
  Diamond Contributor
  May 18, 2020
  daromelman
  
  Yes, it shall be like this
  
  with variations depends on your subscription, not 2016.
Alan_Murray
MVP
May 17, 2020
SergeiBaklan
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.