Hi everyone,
I'm brand new here, but I've heard good things from co-workers. I am working on cleaning up our database for targeted marketing lists. First, I want to create a master list of everything that we have. The problem is, the companies are listed in one spreadsheet, and the contacts are listed in another. I can match them by company ID (column B). I color coded the lists separately to make them easy to identify. Is there a formula or easier way to take the company name and match it to the contacts name (column C)? I have been doing it manually and then color coding it another color to transfer to another sheet later on.
Some companies have no contacts, and some have multiple, so it's not a nice every-other pattern either. Anyone have any suggestions? Thanks in advance!
-B
Bookmarks