IF column comparison + 1 more criteria

horizonflame

Board Regular
Joined
Sep 27, 2018
Messages
145
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

Well-known Member
Joined
Oct 17, 2015
Messages
604
Office Version
2016
Platform
Windows
Try:
Code:
=IF(AND(COUNTIF($B$3:$B$3000,$A3)=0,$C3<>""),"NO","YES")
 

Forum statistics

Threads
1,082,501
Messages
5,365,942
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top