Excel Data Merge

[Closed]
Report
Posts
1
Registration date
Monday August 20, 2012
Status
Member
Last seen
August 20, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
have you looked into use of vlookup?
See this also
https://ccm.net/forum/affich-665775-matching-and-adding-data