Comparing Data in a cell to data in multiple columns

Column A and B has multiple data in each Cell. I want to compare data input in column c to the Column A n Column B.
Eg if data input in Cell C1 matches any Data in Column A or Column B.
If Data input in C1 Matches any Data in Column A then check if D1 is greater than 2 if both are true then display "X" in E1
If Data input in C1 Matches any Data in Column B then check if D1 is greater than 4 if both are true then display "X" in E1

      A                       B                        C                     D            E

1    ZZ                      	XA	            	 zx                    6
2    ZX            	        XB		                      
3    ZY                       XC

codes i have tried

 
=IF(C1=A:B,D1>2"x","") 
=IF(AND(c1=A:B,4>D1),"x","")