Combining data in Excel 2007

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.