Returning a value problem.

[dtman85]

I copied a big data file from two websites and pasted into two worksheets, over 10,000 rows of data.
Worksheet 1

Name	Year	Salary
John Smith	2016	1,500
Eric Smith	2015	2,500

<tbody>
</tbody>

Worksheet 2

Year	Name	Salary	win
2016	John Smith		100
2015	Eric Smith		50

<tbody>
</tbody>

In worksheet 2, under the salary column, I used the sumifs formula to return the value of salary from worksheet one to two but I get a value of "0"for each cell. When I retyped the pasted names "John Smith" to "John Smith" on worksheet 2, I get the correct return value. Both cells from worksheet 1 & 2 are in the general format.

How can I solve this because is not ideal to retype all the pasted names?

Thanks in Advance.

 

[AhoyNC]

You're welcome. Thanks for the feedback.