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
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