Help to find "Relationship" function on MAC version 16.43

%3CLINGO-SUB%20id%3D%22lingo-sub-1982275%22%20slang%3D%22en-US%22%3EHelp%20to%20find%20%22Relationship%22%20function%20on%20MAC%20version%2016.43%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982275%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20a%2016.43%20version%20of%20Excel%20for%20Mac%20and%20I%20can't%20find%20the%20%22Relationship%22%20function%2C%20it%20is%20nowhere.%20Can%20you%20please%20tell%20me%20if%20there%20is%20some%20way%20I%20can%20activate%2Fadd%20this%20function%20or%20any%20other%20alternative%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1982275%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1982314%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20find%20%22Relationship%22%20function%20on%20MAC%20version%2016.43%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F899731%22%20target%3D%22_blank%22%3E%40Tengizi%3C%2FA%3E%26nbsp%3BForgive%20me%20for%20asking%2C%20but%20what%20is%20%22the%20relationship%20function%22%3F%20Mac%20user%20myself%20and%20have%20difficulty%20imagining%20what%20you%20refer%20to.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1982316%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20find%20%22Relationship%22%20function%20on%20MAC%20version%2016.43%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982316%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20Here%20you%20can%20find%20what%20it%20is%20about.%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3%23%3A~%3Atext%3DGive%2520each%2520table%2520a%2520meaningful%2Cone%2520column%2520contains%2520unique%2520values%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3%23%3A~%3Atext%3DGive%2520each%2520table%2520a%2520meaningful%2Cone%2520column%2520contains%2520unique%2520values%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1982384%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20find%20%22Relationship%22%20function%20on%20MAC%20version%2016.43%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982384%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F899731%22%20target%3D%22_blank%22%3E%40Tengizi%3C%2FA%3E%26nbsp%3BI%20see!%20Unfortunately%2C%20this%20is%20NOT%20supported%20by%20Excel%20for%20the%20Mac.%20It's%20a%20Windows%20only%20feature%20for%20version%202013%20and%20later%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-12%20at%2015.19.34.png%22%20style%3D%22width%3A%20894px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F240000i1729D76BC4B5AA45%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-12%20at%2015.19.34.png%22%20alt%3D%22Screenshot%202020-12-12%20at%2015.19.34.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I have a 16.43 version of Excel for Mac and I can't find the "Relationship" function, it is nowhere. Can you please tell me if there is some way I can activate/add this function or any other alternative?

6 Replies

@Tengizi Forgive me for asking, but what is "the relationship function"? Mac user myself and have difficulty imagining what you refer to.

@Tengizi I see! Unfortunately, this is NOT supported by Excel for the Mac. It's a Windows only feature for version 2013 and later:

Screenshot 2020-12-12 at 15.19.34.png

@Riny_van_Eekelen Okay and there is no other way we can do the same thing? 

@Riny_van_Eekelen 

Actually that is supporting of data model - not for Mac.

@Tengizi 

That is building of virtual relationships, aka XLOOKUP() or like.