Index match four columns true false

%3CLINGO-SUB%20id%3D%22lingo-sub-2320365%22%20slang%3D%22en-US%22%3EIndex%20match%20four%20columns%20true%20false%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2320365%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20four%20columns%20that%20are%20filled%20up%20by%20SL%20and%20JT.%20I%20need%20to%20do%20an%20analysis%20to%20calculate%20the%20similarity%20of%20categories%20SL%20and%20JT%20have%20in%20common.%20I%20want%20to%20show%20this%20similarity%20in%20percentage.%20For%20example%2C%20first%20row%20is%200%20as%20none%20of%20the%20values%20match%20up.%20Second%20is%2050%25%20as%20we%20have%207's%20matching.%20same%20logic%20is%20for%20third%20row%20and%20for%20fourth%2C%20it%20is%200.%20Could%20you%20please%20suggest%20the%20formula%20that%20can%20automate%20the%20similarity%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22947%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22170%22%3EPrimary%20Category%20(SL)%3C%2FTD%3E%3CTD%20width%3D%22174%22%3EPrimary%20Category%20(JT)%3C%2FTD%3E%3CTD%20width%3D%22190%22%3ESecondary%20Category%20(SL)%3C%2FTD%3E%3CTD%20width%3D%22231%22%3ESecondary%20Category%20(JT)%3C%2FTD%3E%3CTD%20width%3D%22182%22%3Efirst%20and%20second%20category%20analysis%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2320365%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-2320960%22%20slang%3D%22en-US%22%3ERe%3A%20Index%20match%20four%20columns%20true%20false%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2320960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044287%22%20target%3D%22_blank%22%3E%40suchetaitsme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20I%20understood%20the%20logic%20correctly%2C%20perhaps%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20555px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277800iF9DCE0C61AE45110%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have four columns that are filled up by SL and JT. I need to do an analysis to calculate the similarity of categories SL and JT have in common. I want to show this similarity in percentage. For example, first row is 0 as none of the values match up. Second is 50% as we have 7's matching. same logic is for third row and for fourth, it is 0. Could you please suggest the formula that can automate the similarity? 

 

Primary Category (SL)Primary Category (JT)Secondary Category (SL)Secondary Category (JT)first and second category analysis
672  
77   
11   
653  
1 Reply

@suchetaitsme 

Not sure I understood the logic correctly, perhaps

image.png