IF column comparison + 1 more criteria

[horizonflame]

Hi,

I am performing two IF criteria:

1) Compare Column B to Column A for a matched cell value
2) Column C contains any value

I want "NO" to be no cell match and any value found

I have the below so far:

=IF(COUNTIF($B$3:$B$3000,$A3)=0,"NO","YES")

Many thanks

 

[Trevor_S]

Try:

=IF(AND(COUNTIF($B$3:$B$3000,$A3)=0,$C3<>""),"NO","YES")