Can't find XLOOKUP in SAC-T

%3CLINGO-SUB%20id%3D%22lingo-sub-1222039%22%20slang%3D%22en-US%22%3ECan't%20find%20XLOOKUP%20in%20SAC-T%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222039%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%2C%20I%20installed%20O365%20SAC-T%20and%20update%20to%20version%202002(12527.20278).%3CBR%20%2F%3EBut%20I%20can't%20use%20XLOOKUP%20function%20despite%20the%20fact%20that%20I%20can%20use%20it%20in%20Monthly%20Channel.%3C%2FP%3E%3CP%3EI%20think%20I%20understood%20follow%20sentence.%20It%20doesn%E2%80%99t%20make%20sense...%3CBR%20%2F%3E---%3CBR%20%2F%3EA%20Semi-Annual%20Channel%20(Targeted)%20with%20new%20features%20is%20expected%20to%20be%20released%20twice%20a%20year%2C%20in%20March%20and%20September.%20New%20features%20aren't%20added%20to%20Semi-Annual%20Channel%20(Targeted)%20at%20any%20other%20time.%20The%20features%20that%20are%20included%20in%20Semi-Annual%20Channel%20(Targeted)%20are%20features%20that%20have%20been%20released%20previously%20in%20Monthly%20Channel.%3CBR%20%2F%3E---%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist%20me...%3C%2FP%3E%3CP%3EThank%20you%20kindly%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1222039%22%20slang%3D%22en-US%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-1222100%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%20in%20SAC-T%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222100%22%20slang%3D%22en-US%22%3EI%20expect%20you'll%20have%20to%20wait%20until%20September%20for%20XLOOKUP%20to%20arrive%20in%20Semi-annual.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222848%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%20in%20SAC-T%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222848%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F456202%22%20target%3D%22_blank%22%3E%40ninnin8492%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20citation%20is%20clear%20enough.%20It%20says%20that%20new%20functionality%20is%20distributed%20on%20channel%20basis%2C%20not%20on%20builds%20basis.%20You%20may%20have%20exactly%20the%20same%20version%2Fbuild%20number%20on%20Monthly%20and%20Semi-Annual%20channels%2C%20new%20functionality%20will%20work%20on%20first%20one%20and%20won't%20be%20available%20on%20second%20one.%20Actually%20you%20have%20the%20code%20of%20the%20new%20functionality%20within%20the%20build%20in%20both%20cases%2C%20but%20it%20is%20activated%20or%20not.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1223941%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%20in%20SAC-T%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1223941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%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%3EThank%20you%20for%20your%20quick%20reply!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20more%20quote...%20from%20support%20article.%3C%2FP%3E%3CP%3E(%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E---%3CBR%20%2F%3ENote%3A%20This%20function%20is%20currently%20available%20to%20Office%20365%20subscribers%20in%20the%20Monthly%20channel.%20It%20will%20be%20available%20to%20Office%20365%20subscribers%20in%20the%20Semi-Annual%20channel%20starting%20in%20July%202020.%3CBR%20%2F%3E---%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20that%20SAC-T%20will%20be%20able%20to%20use%20XLOOKUP%20by%20July%202020...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi All,

 

Today, I installed O365 SAC-T and update to version 2002(12527.20278).
But I can't use XLOOKUP function despite the fact that I can use it in Monthly Channel.

I think I understood follow sentence. It doesn’t make sense...
---
A Semi-Annual Channel (Targeted) with new features is expected to be released twice a year, in March and September. New features aren't added to Semi-Annual Channel (Targeted) at any other time. The features that are included in Semi-Annual Channel (Targeted) are features that have been released previously in Monthly Channel.
---

Can someone please assist me...

Thank you kindly for any assistance.

4 Replies
Highlighted
I expect you'll have to wait until September for XLOOKUP to arrive in Semi-annual.
Highlighted

@ninnin8492 

IMHO, citation is clear enough. It says that new functionality is distributed on channel basis, not on builds basis. You may have exactly the same version/build number on Monthly and Semi-Annual channels, new functionality will work on first one and won't be available on second one. Actually you have the code of the new functionality within the build in both cases, but it is activated or not. 

Highlighted

@Jan Karel Pieterse @Sergei Baklan 

Thank you for your quick reply!!

 

One more quote... from support article.

(https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929?ui=en...)

 

---
Note: This function is currently available to Office 365 subscribers in the Monthly channel. It will be available to Office 365 subscribers in the Semi-Annual channel starting in July 2020.
---

 

I believe that SAC-T will be able to use XLOOKUP by July 2020...

Highlighted
"starting in July 2020" does mean that it may take some time before you actually see it enabled on your tenant. I don't know how fast they release it to everyone on the same channel, but I do know it isn't instantly and may take weeks, if not months for everyone to get it.