Check to see if 2 rows match in excel

[NewUser2]

Hi, my problem is I have a large database and need to see if 2 rows match Anywhere in the database. HOWEVER, say there are 15 columns, I only want to see if 4 specific columns match.

I tried: =IF(AND(C:C=C2,E:E=E2,F:F=F2,G:G=G2),"True","False")
and it seemed to be working, but after testing further it doesnt seem to work.. (I also tried this as an array)

The goal with the above is to see if cell C2 = any other cell in column C AND E2 = any other cell in column E, etc.. all 4 variables have to match for it to get marked as "True"

Thanks for your help!

 

[Caribeiro77]

There must be some other easy way to do it but here's mine:

=IFNA(AND(MATCH(C2,C:C,0),MATCH(E2,E:E,0),MATCH(F2,F:F,0),MATCH(G2,G:G,0)),"FALSE")