Combining data in Excel 2007

Closed
carstarr - May 10, 2010 at 11:00 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 10, 2010 at 11:05 AM
I have a list of names on one worksheet (Sheet2).

Doe, Jane
Smith, Joe
Hawthorn, Mya

On a seperate tab in the same workbook I have another list of names with some other information (Sheet1).

Column A Column E
Smith, Joe No
Doe, Jane 2. Good
Hawthorn, Mya 4. Bad

I want to search Sheet1 and copy what is in column E on Sheet2 for that person into column B on sheet1.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 10, 2010 at 11:05 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
0