SOLVED

xlookup function not available

%3CLINGO-SUB%20id%3D%22lingo-sub-1132475%22%20slang%3D%22en-US%22%3Exlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132475%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20using%20office%20365%20latest%20version%20of%20MS%20excel%202019.%20but%20i%20could%20not%20find%20xlookup%20function%20in%20t%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1132475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1132666%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132666%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535365%22%20target%3D%22_blank%22%3E%40mmirfan%3C%2FA%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%20Excel%202019%20is%20NOT%20part%20of%20Office%20365.%20Can%20you%20open%20Excel%20and%20go%20to%20File%2C%20Account%20page%2C%20what%20does%20it%20say%20under%20the%20Office%20logo%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20991px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167654iD9E02A97A18F329A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222020-01-28_10-35-53.gif%22%20title%3D%222020-01-28_10-35-53.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1132678%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132678%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167657i97E9465ACE3B01D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22office.png%22%20title%3D%22office.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%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%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1132751%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132751%22%20slang%3D%22en-US%22%3EOdd%20that%20it%20says%20it%20will%20not%20update%2C%20it%20should%20not%20say%20that.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1132755%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132755%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%3BThanks%20for%20your%20valuable%20feedback...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1152125%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1152125%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%3BMy%20office%20already%20updated%20but%20i%20can%20use%20.%20Can%20you%20help%20me%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169093i3B2DEEDFBE828557%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3EXlookup%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1152149%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1152149%22%20slang%3D%22en-US%22%3EXLOOKUP%20is%20not%20yet%20available%20on%20your%20channel%2C%20you'll%20have%20to%20be%20patient%20for%20about%206%20months%20I'm%20afraid.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1996203%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1996203%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%3BI%20created%20a%20spreadsheet%20that%20uses%20XLOOKUP...it%20was%20working%20perfectly.%26nbsp%3B%20A%20few%20days%20later%20I%20launch%20the%20same%20spreadsheet%20and%20XLOOKUP%20is%20no%20longer%20available...does%20this%20sound%20right%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am currently using office 365 latest version of MS excel 2019. but i could not find xlookup function in t

7 Replies

@mmirfan  Excel 2019 is NOT part of Office 365. Can you open Excel and go to File, Account page, what does it say under the Office logo?2020-01-28_10-35-53.gif

best response confirmed by mmirfan (Occasional Contributor)
Odd that it says it will not update, it should not say that.

@Jan Karel Pieterse Thanks for your valuable feedback...

@Jan Karel Pieterse My office already updated but i can use . Can you help me?Capture.PNGXlookup

XLOOKUP is not yet available on your channel, you'll have to be patient for about 6 months I'm afraid.

@Jan Karel Pieterse I created a spreadsheet that uses XLOOKUP...it was working perfectly.  A few days later I launch the same spreadsheet and XLOOKUP is no longer available...does this sound right?