Please check for spaces in your original data.
Try =LEN(A1) and compare the len. If different TRIM your data and try lookup..

--
If this post helps click Yes
---------------
Jacob Skaria


"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?