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
"JM" wrote:

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