Quote Originally Posted by mrice View Post
Try

=IF(AND(COUNTIF(A:B, C1) > 0, D1>2),"x","")
=IF(AND(COUNTIF(A:B, C1) > 0, D1>2),"x","") does work for the first portion -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

however if i change value in C1 to xc and D1 to 3 the outcome should me null however it displays SLA Exceeded as it is equating D1>2

*

Do i need compare column by column

i tried the below equation but get error in value


=IF(AND(COUNTIF(A:A, C1) > 0, J2>2),"x","") + IF(AND(COUNTIF(B:B, C1) > 0, J2>4),"SLA Exceeded","")