Let us know how your data is arranged. and also the formula you have used./
--
If this post helps click Yes
---------------
Jacob Skaria


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