Excel 365 LET not found #Name?

%3CLINGO-SUB%20id%3D%22lingo-sub-1585688%22%20slang%3D%22en-US%22%3EExcel%20365%20LET%20not%20found%20%23Name%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585688%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20office%20365%20ProPlus.%20In%20Excel%20I%20can%20see%20functions%20like%20Filter%2C%20Sequence%2C%20Unique%2C%20and%20other%20dynamic%20array%20functions%2C%20etc.%20but%20for%20some%20strange%20reason%2C%20I%20don't%20see%20the%20LET%20function.%20The%20Intellisence%20does%20not%20recognize%20LET%2C%20furthermore%2C%20I%20get%20a%20%22%23Name%3F%22%20error.%26nbsp%3B%20I%20have%20the%20latest%20version%20Build%20%23%2012527.20988.%20I%20searched%20the%20internet%20for%20this%20error%2C%20but%20nothing.%26nbsp%3B%20any%20help%20would%20be%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1585688%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELET%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELET%20function%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EName%20Error%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENOT%20Found%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587147%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20LET%20not%20found%20%23Name%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F757871%22%20target%3D%22_blank%22%3E%40Loay1166%3C%2FA%3E%2C%26nbsp%3BPicture%20of%20the%20problem%20of%20the%20error.%20is%20this%20new%20functionality%20in%20beta%20and%20not%20fully%20released%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Loay1166_0-1597334707436.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212255i80A0E0E710D1B8A9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Loay1166_0-1597334707436.png%22%20alt%3D%22Loay1166_0-1597334707436.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have office 365 ProPlus. In Excel I can see functions like Filter, Sequence, Unique, and other dynamic array functions, etc. but for some strange reason, I don't see the LET function. The Intellisence does not recognize LET, furthermore, I get a "#Name?" error.  I have the latest version Build # 12527.20988. I searched the internet for this error, but nothing.  any help would be great.

1 Reply

@Loay1166, Picture of the problem of the error. is this new functionality in beta and not fully released?

Loay1166_0-1597334707436.png