comparing 2 excel spreadsheets

[Davidi]

I'm wondering if the following can be done in Excel and if not, if anyone can
recommend a 3rd party tool or script that can do this.

I have two spreadsheets. Spreadsheet1 consists of a thousand Contacts
including columns First Name and Last Name. Spreadsheet2 has a similar list
of Contacts with (First Name, Last Name, AND Email Address). I'd like
Excel/script to scan the records and if the First Name and Last Name in
Spreadsheet2 exists in Spreadsheet1, to copy the email address field of that
contact to Spreadsheet1.

Any ideas? Thanks.

 

[Martin Fishlock]

Hi David:

There are a couple of ways to do it but the way I prefer is to make a new
column in your list of contacts with the email addresses (sc2). Insert the
column in column C.

Now in the first row in column c put (cell c2?) =a2 &":"&b2.
Ccopy this down for all the cells where you have contacts.
This has made a unique key or id.

Now back in the other spreadsheet (sc1) in the column where you want the
addresses put this

=vlookup(a2&":"&b2,sc2!c:d,2,false)

you may need to adjust the sc2 address to get it to work, the easiest way to
do it is in the function box select the columns.

this should work.

You may have problems with spaces, capitalization and minor differences in
names and duplicate names.

This will get you started.