Enter Name / Address Into Lead Database

I have? 4 XCel spreadsheets.? Two have complete name, company and addresses.? ? Two? have partial information.? What needs to be done is the following: 1.? Combine the 2 with complete information? into one. 2.? For the ones with? partial information, if the name is already on the combined list, ignore it.? Otherwise, add it to the list.? You may need to? find the company street address, etc.? I have a way for you to do? it. The result is a combined list of all names with full names, company and addresses.