Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing 2 excel spreadsheets
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing 2 excel spreadsheets
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. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Davidi" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing two spreadsheets | Excel Discussion (Misc queries) | |||
Comparing spreadsheets | Excel Worksheet Functions | |||
Comparing Two Spreadsheets | Excel Worksheet Functions | |||
comparing excel spreadsheets from command line | Excel Discussion (Misc queries) | |||
comparing 2 spreadsheets | Excel Discussion (Misc queries) |