Forum Discussion
Countifs and match help needed
Hi all, I am trying to create a formula that would tell me if any of the names on my first sheet are in sheet 2 or 3. If they are I want a "no" and if they aren't I want a yes. I tried Countifs and...
In B2 on Sheet1:
=IF(COUNTIF(restr!A:A,A2)+COUNTIF('restrict 2'!A:A,A2),"No","Yes")
Fill down.
this worked! thanks so much!