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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Year[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]2016[/TD]
[TD]1,500[/TD]
[/TR]
[TR]
[TD]Eric Smith[/TD]
[TD]2015[/TD]
[TD]2,500[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Name[/TD]
[TD]Salary[/TD]
[TD]win[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]John Smith[/TD]
[TD][/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]Eric Smith[/TD]
[TD][/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]

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.