SOLVED

Can't find XLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-914751%22%20slang%3D%22en-US%22%3ECan't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-914751%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3EI%20have%20been%20using%20Office%20365%20and%20also%20joined%20in%20insider.%20But%20unfortunately%20cant%20find%20XLOOKUP%20function%20inside.%3C%2FP%3E%3CP%3ELooking%20forward%20your%20suggestion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanking%20you%26nbsp%3B%3C%2FP%3E%3CP%3EMahmud%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-914751%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-915047%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915047%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426166%22%20target%3D%22_blank%22%3E%40Mahmudcma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20your%20version%20of%20Excel%20in%20File-%26gt%3BAccount.%20If%20it's%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20514px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137611iEABFD1368D2CFEAB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20Office%20Insider%20and%20version%20as%20above%20or%20close%20to%20it%2C%20you%20shall%20have%20XLOOKUP.%20Send%20the%20frown%20to%20Microsoft%20then.%20If%20not%2C%20update%20your%20Office.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-915058%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915058%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%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20reply.%20Yes%20I%20do%20have%20the%20same%20version%20of%20excel.%20but%20still%20I%20cant%20find%20it.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137612i7536AB92DB632DB5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture%20013.JPG%22%20title%3D%22Capture%20013.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-915117%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915117%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426166%22%20target%3D%22_blank%22%3E%40Mahmudcma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStrange%2C%20I%20was%20sure%20it's%20now%20for%20all%20Insiders%20Fast.%20When%20it's%20question%20to%20Microsoft.%20Options%20are%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20find%20blog%20in%20this%20community%20where%20XLOOKUP%20was%20announced%20and%20ask%20you%20question%20in%20comments%20directly%20mentioning%20the%20author%20of%20the%20blog%3B%3C%2FP%3E%0A%3CP%3E-%20Send%20a%20Frown%20from%20File-%26gt%3BFeedback%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-915121%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915121%22%20slang%3D%22en-US%22%3EThanks%20a%20lot%20!!%3CBR%20%2F%3EJust%20tried%20again%20and%20I%20found%20the%20function.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-915152%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426166%22%20target%3D%22_blank%22%3E%40Mahmudcma%3C%2FA%3E%26nbsp%3B%2C%20great%2C%20thank%20you%20for%20the%20update.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177559%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177559%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%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20excel%20version%20is%20the%20below%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cricol_0-1581950253636.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171485iB157A6C41248AAC5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22cricol_0-1581950253636.png%22%20alt%3D%22cricol_0-1581950253636.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I%20cannot%20use%20xlookup%20in%20my%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edo%20you%20have%20any%20suggestion%20how%20to%20use%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177569%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560682%22%20target%3D%22_blank%22%3E%40cricol%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20available%20for%20semi-annual%20channel%2C%20perhaps%20this%20fall.%20You%20may%20shift%20on%20Monthly%20channel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177578%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177578%22%20slang%3D%22en-US%22%3EI%20will%20check%20if%20my%20company%20allow%20that.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2183425%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2183425%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Excel%20version%20is%20the%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22abrahaodcs_0-1614817024671.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F260712iD1F97FA28A8F1F7B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22abrahaodcs_0-1614817024671.png%22%20alt%3D%22abrahaodcs_0-1614817024671.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2183427%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2183427%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%26nbsp%3BI%20have%20the%20same%20problem.%3CBR%20%2F%3EMy%20Excel%20version%20is%20the%20below%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22abrahaodcs_0-1614817234469.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F260713iD2A22B4543733003%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22abrahaodcs_0-1614817234469.png%22%20alt%3D%22abrahaodcs_0-1614817234469.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

Hi Everyone,

I have been using Office 365 and also joined in insider. But unfortunately cant find XLOOKUP function inside.

Looking forward your suggestion.

 

Thanking you 

Mahmud

10 Replies

@Mahmudcma 

Please check your version of Excel in File->Account. If it's like

image.png

If Office Insider and version as above or close to it, you shall have XLOOKUP. Send the frown to Microsoft then. If not, update your Office.

@Sergei Baklan 

Thank you so much for your reply. Yes I do have the same version of excel. but still I cant find it. Capture 013.JPG

 

best response confirmed by Mahmudcma (New Contributor)
Solution

@Mahmudcma 

Strange, I was sure it's now for all Insiders Fast. When it's question to Microsoft. Options are

 

- find blog in this community where XLOOKUP was announced and ask you question in comments directly mentioning the author of the blog;

- Send a Frown from File->Feedback

Thanks a lot !!
Just tried again and I found the function.

@Mahmudcma , great, thank you for the update.

@Sergei Baklan 

 

My excel version is the below 

cricol_0-1581950253636.png

 

and I cannot use xlookup in my excel.

 

do you have any suggestion how to use it?

 

 

@cricol 

It's not available for semi-annual channel, perhaps this fall. You may shift on Monthly channel.

I will check if my company allow that.

@Sergei Baklan I have the same problem.
My Excel version is the below

abrahaodcs_0-1614817234469.png

 

@abrahaodcs 

Do I understand correctly you don't have XLOOKUP() on English 365, current version on Beta channel? That's unbelievable, it has to be. Perhaps problems could be with Windows 7, but even in this case I doubt.

That's only to Send a Frown from Help->Feedback or open support ticket.