Comparing Lists

[tly0227]

I've got 2 questions...

1) I have 2 sheets...1 of them is a list of organizations with their address and other info. The 2nd list is people with their contact info (name, title, organization, email). What I need to do is compare the organization names on sheet A, with the organization names on Sheet B. Essentially, I need to make sure that I have the contact info for at least 1 person at each of the organizations on Sheet A. There's thousands of rows on each of these...so I'm hoping there's an easy way I can compare those lists and then be able to quickly see which ones I still need to get contact info for.

2) On Sheet B, I need to know if there is a contact listed for an organization that isn't on Sheet A so that the org can be added to Sheet A.

I'm thinking maybe both of these can be done with if/then formula's, but not positive on that...

 

[AlphaFrog]

1.) Put this on sheet A
=COUNTIF('Sheet B'!C:C, A1)>0
A1 is the organization on sheet A
'Sheet B'!C:C is the organization column on Sheet B
The formula will return TRUE if there is any match for the organization or FALSE if not

2.)Do the opposite on Sheet B
=COUNTIF('Sheet A'!A:A, C1)>0

 

[tly0227]

Thanks! I knew the formula I needed had 'if' in it...I just could remember which one, lol. That worked though, so thanks!