Xlookup function not available

%3CLINGO-SUB%20id%3D%22lingo-sub-2535965%22%20slang%3D%22en-US%22%3EXlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535965%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20currently%20use%20Mac%2C%20I%20have%20the%20latest%20Microsoft%20365%20but%20apparently%2C%20there's%20no%20Xlookup%20function%20in%20my%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20this%3F%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%22Screen%20Shot%202021-07-11%20at%2010.18.51%20pm.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294858iA456F56B518F3B29%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-07-11%20at%2010.18.51%20pm.png%22%20alt%3D%22Screen%20Shot%202021-07-11%20at%2010.18.51%20pm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-07-11%20at%2010.21.44%20pm.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294859iD30BA9CF615C038B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-07-11%20at%2010.21.44%20pm.png%22%20alt%3D%22Screen%20Shot%202021-07-11%20at%2010.21.44%20pm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2535965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2536011%22%20slang%3D%22en-US%22%3ERe%3A%20Xlookup%20function%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2536011%22%20slang%3D%22en-US%22%3EI%E2%80%98m%20Not%20an%20Mac%20Office%20expert%2C%20but%20it%20looks%20like%20you%20have%20Office%202019%20and%20not%20365.%3CBR%20%2F%3EXLOOKUP%20us%20not%20aviable%20in%202019.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I currently use Mac, I have the latest Microsoft 365 but apparently, there's no Xlookup function in my Excel. 

Can someone help me with this?

 

Screen Shot 2021-07-11 at 10.18.51 pm.png

Screen Shot 2021-07-11 at 10.21.44 pm.png

1 Reply
I‘m Not an Mac Office expert, but it looks like you have Office 2019 and not 365.
XLOOKUP us not aviable in 2019.