tly0227
New Member
- Joined
- Oct 2, 2012
- Messages
- 37
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...
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...