Matching - V Lookups

[Guest]

I'm Matching two files based on last name. I've made sure the last names in
each file are properly formatted (proper function - first letter capped) and
the last names in each file are sorted ascending and located in column A.
When I look at the two files I see obvious matches just by glancing through
it, but the V lookups are showing none.

I've done hundreds of these things............could someone please tell me
whats wrong

thanks

 

[Guest]

Look for blank characters padded at the end of the name... "Smith" and "Smith
" are not the same thing and a Vlookup will return nothing...