Hi,
If you retype the names and works there is something different, try in both
columns

=trim(a1)
and copy all the way down

"Confused" wrote:

The data is arranged in 2 excel spreadsheets in columns. The names are
written the same way and both formatted as text. I hve tried formatting both
columns same way. same problem. If I retype both names in the two
spreadsheets the correct info is returned.

"Eduardo" wrote:

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?