Excel Data Merge

Closed
wbrowing71 Posts 1 Registration date Monday August 20, 2012 Status Member Last seen August 20, 2012 - Aug 20, 2012 at 01:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 11, 2012 at 10:38 AM
Hello,
I have two excel sheets that are similar. Sheet one has a master list of contractors that are active and sheet two has another list of contractors that are active and their email and phone number. Sheet two is more accurate and has contractors that sheet one doesn't. I do not want these contractors in sheet one. Sheet one has over 3000 contractors and sheet two has over 9000. Way too many to look up individually. Row one on both sheets goes as follows: first name; last name; active; email; cell. Again, sheet one's email and cell rows are completely empty. I would like to have a formula that looks for all the first and last names (together) from sheet one in sheet two and then imports all the data associated with these names in sheet two to the appropriate place in sheet one. Any help here would be great. I have been racking my brain on this one.



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 11, 2012 at 10:38 AM
have you looked into use of vlookup?
See this also
https://ccm.net/forum/affich-665775-matching-and-adding-data
0