XLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-1397242%22%20slang%3D%22es-ES%22%3EXLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397242%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CSPAN%3EHello%2C%20i%20can't%20find%20the%20xlookup%20function%20in%20excel.%20I%20have%20the%20office%20365%20version%20and%20understand%20it%20should%20be%20there.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1397242%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397334%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397334%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670488%22%20target%3D%22_blank%22%3E%40daromelman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20shall%20be%2C%20but%20so%20far%20not%20on%20semi-annual%20channel.%20If%20you%20are%20on%20it%2C%20XLOOKUP%20will%20appear%20some%20later.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397346%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397346%22%20slang%3D%22en-US%22%3EHello%2C%20go%20to%20File%20%26gt%3B%20Account%20%26gt%3B%20Click%20on%20Update%20Now...%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20should%20be%20available%20if%20you're%20on%20Microsoft%20365%20Insider%20or%20Monthly%20Channel%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397506%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397506%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670488%22%20target%3D%22_blank%22%3E%40daromelman%3C%2FA%3E%20I%20can%20see%20it%20my%20Excel%202019%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397544%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402789%22%20target%3D%22_blank%22%3E%40AshaKantaSharma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EReally%3F%20When%20it%20appeared%20on%202019%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397629%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397629%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670488%22%20target%3D%22_blank%22%3E%40daromelman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20switch%20to%20the%20Monthly%20channel%20of%20Microsoft%20365%20with%20this%20guide%20-%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fbit.ly%2F2G8qHhx%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%3Ehttp%3A%2F%2Fbit.ly%2F2G8qHhx%3C%2FFONT%3E%3C%2FA%3E%20and%20get%20XLOOKUP%20and%20also%20FILTER%20etc%20today.%20It%20takes%20just%20a%20couple%20of%20minutes.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397646%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F166840%22%20target%3D%22_blank%22%3E%40Alan%20Murray%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20that%20could%20be%20useful%20if%20switch%20from%20one%20channel%20to%20another%20from%20time%20to%20time.%20If%20on%20permanent%20basis%20better%20with%20ODT%20or%20ask%20IT%20to%20switch.%20If%20we%20speak%20about%20corporate%20environment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397669%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3EAbsolutely.%20This%20is%20assuming%20people%20have%20the%20admin%20rights%20to%20change%20it%20-%20as%20you%20say%20in%20a%20corporate%20setting%20this%20may%20not%20be%20possible%2C%20or%20wise%20to.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397955%22%20slang%3D%22es-ES%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397955%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply.%20I%20put%20the%20menu%20update%2C%20it%20was%20updated%2C%20but%20the%20new%20functions%20(FILTER%2C%20XLOOKUP)%20still%20do%20not%20appear.%20The%20strange%20thing%20is%20that%20despite%20having%20office%20365%2C%20it%20appears%20to%20me%20that%20I%20have%20office%202016%20Professional%20Plus.%20Maybe%20that's%20the%20reason.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1398439%22%20slang%3D%22en-US%22%3ERe%3A%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1398439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670488%22%20target%3D%22_blank%22%3E%40daromelman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20it%20shall%20be%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20253px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192483iC987B6107C53E314%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewith%20variations%20depends%20on%20your%20subscription%2C%20not%202016.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

@daromelman 

It shall be, but so far not on semi-annual channel. If you are on it, XLOOKUP will appear some later.

Highlighted
Hello, go to File > Account > Click on Update Now...


It should be available if you're on Microsoft 365 Insider or Monthly Channel
Highlighted

Hi @daromelman I can see it my Excel 2019 

Highlighted

@AshaKantaSharma 

Really? When it appeared on 2019?

Highlighted

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

Highlighted

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

Highlighted

@Sergei Baklan

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.

Highlighted

@Sergei Baklan 

 

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.

Highlighted

@daromelman 

Yes, it shall be like this

image.png

with variations depends on your subscription, not 2016.