How can I check to see if 3 values exist in 3 other cells in the same row?

[statiCat]

I am trying to determine the following:


Are the values in G2, H2, and I2 in A2: C2, in any order?
Are the values in J2, K2, and L2 in D2:F2, in any order?
And then if both conditions are True I want M to say "match" or "no_match"




But I am getting "#Value!" What am I doing wrong?


B,C,E,F,H,I,K,L can be """" (empty string) or may have values. In this case they are all """".


My function: "=IF(AND(OR(($G1=$A1,$G1=$B1,$<wbr>G1=$C1),OR($J1=$D1,$J1=$E1,$<wbr>J1=$F1))),"match","no_match")"

 

[JoeMo]

I am trying to determine the following:


Are the values in G2, H2, and I2 in A2: C2, in any order?
Are the values in J2, K2, and L2 in D2:F2, in any order?
And then if both conditions are True I want M to say "match" or "no_match"




But I am getting "#Value!" What am I doing wrong?


B,C,E,F,H,I,K,L can be """" (empty string) or may have values. In this case they are all """".


My function: "=IF(AND(OR(($G1=$A1,$G1=$B1,$<wbr>G1=$C1),OR($J1=$D1,$J1=$E1,$<wbr>J1=$F1))),"match","no_match")"

Your formula doesn't seem to address the requirements in bold above. I think this formula, although quite clumsy, does.

=IF(ISNA(MATCH(A2,$G$2:$I$2,0)),"no match",IF(ISNA(MATCH(B2,$G$2:$I$2,0)),"no match",IF(ISNA(MATCH(C2,$G$2:$I$2,0)),"no match",IF(ISNA(MATCH(D2,$J$2:$L$2,0)),"no match",IF(ISNA(MATCH(E2,$J$2:$L$2,0)),"no match",IF(ISNA(MATCH(F2,$J$2:$L$2,0)),"no match","match"))))))