• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Search For Data in Excel and Copy to Another Spreadsheet

Hello – I need some help with Excel. In Spreadsheet A I have all the data I need except for e-mail address, the column in Spreadsheet A for the e-mail address is Column D. Spreadsheet B has the e-mail address in Column D. Is there a way to search on the Last Name & First Name from Spreadsheet A to Spreadsheet B, find the e-mail address for that user in Spreadsheet B and copy and paste it into Spreadsheet A? In spreadsheet A, the last name is in column B and the first name is in column C. In Spreadsheet B, the last name is in column A and the first name is in column B. Spreadsheet A has 1,210 rows of data and Spreadsheet B has 15,037 rows of data.

Thanks
0
vhaperbaugub
Asked:
vhaperbaugub
1 Solution
 
davorinCommented:
0
 
Curt LindstromCommented:
1.Insert a temporary help column at column A in file B where you enter
=A1&B1
and copy down to the end of data.
2. Enter this VLOOKUP formula in column D in file A and copy down to the end of data
=VLOOKUP(B1&C1,[B.xls]Sheet1!$A:$E,5,FALSE)
3.Copy column D in file A and paste special as values
4. Delete temporary help column in file B

Regards,
Curt
0
 
vhaperbaugubAuthor Commented:
That worked......Thanks!
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now