Hi,
Check that the names are identical sometimes one of them has an space or
other simbol,

2) Highlight both columns and do text to columns

"Confused" wrote:

I am using Vlookup to find names in one file and replace it with emails from
another. The two names exist in both files but i get all #N/A . How can I
resolve this?