Compatibility issue?

Ok, I have a doc that was created in excel 2010(or was it 2007?) and I have it opened in excel 2013.
I am running a Vlookup but returning a value of N/A. I make sure that the cell in both worksheets used in the Vlookup are formatted the same way, everything is spelled exactly the same etc.. The only thing that makes the formula works is if I copy and paste the common identifier from one sheet to the other. I cant for the life of me figure out what is different in each cell so I have to assume its a compatibility issue. Anyone know if this is the case, and if so, how I can fix it so that I dont have to copy and paste forever?

OK attached is the file.
I simplified it and changed real names.

there are 2 sheets
As you can see, some of the last names on sheet1 dont match up with the accurate records on sheet2.

For the ones that don't match up, copy and paste the correct firstname from sheet2 and override the existing matching first name in sheet1
You'll see that now the last name shows correctly. But can you figure out what changed in the cell?? Also, I have TRUE so the match shouldnt need to be exact anyway.

Thanks!

Thank you !
How do I see the spaces? and how do I remove the spaces? Or is there a way to not count spaces after the last letter in a string?

Thanks for the help! One more question:
I now want to past the additional fields that correspond to the row in which I performed the vlookup on. So in sheet 2 of the attached doc in the thread, columns c, d, e should also be pasted into sheet1 in columns c, d, e

Use the TRIM function in your lookup data to remove the spaces. I created an extra column for you in Sheet2, see "BLUE".

^^Thanks, I didn't know you could trim a column like that.