Need help merging selective data

J

JM

I've got two worksheets, both of them customer lists with company/contact
information. One contains the company name and phone number. The other
contains company name and address. The lists contain mostly the same
companies, but there are variations. The second list has companies not
included in the first, and vice versa. The first list is more accurate.

Basically, I want the addresses in the second list to become part of the
first list, matched up with the appropriate company name, of course. I need
to tell Excel to compare the company name fields and import the address when
there is a match. I don't know how to do this.

Can anyone teach me to do this?

Thank you,

JM
 
G

Guest

You would use a vlookup formula.
vlookup(a2,range,2,false)

Assumptions:
A2= company name on first list
Range= the data from the second list you want to bring in, make sure the
company name on the second list is the first column
2= column number, in this case it would be the address in sheet 2

that should do the trick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top