31C0D322 128805 The date from each source is formatted as text and all
VLookup lines work fine when I paste from one source but not when the same
data is pasted from another source. I have created a template and am trying
to reproduce the results. Sorry for the separate posts to answer your
question. It has been a long day


"JLatham" wrote:

What version of Excel?

And more importantly, what formula is returning #NA ? Is it a VLOOKUP() or
HLOOKUP()?

Do you get #NA for ALL formulas involved, or just some?

Examples of the formula and data involved would be good to have here.

I suspect that the data from the "other source" that's giving you the #NA is
possibly text, and there may be invisible characters (spaces or tabs most
likely culprits) as part of that data. Added spaces would probably be
noticeable if they're at the start of the data, but not if they're at the end
of it.

"Ed2" wrote:

I have a 3 page spreadsheet which works flawlessly when I paste data copied
from one source but returns #NA with the same data from another source. I
have checked properties, number vs. test formats and such but to no avail.
AQny suggestions?