On Fri, 26 Dec 2008 20:52:42 GMT, "mkcma" <u48424@uwe wrote:

I believe I have tried everything and cannot get these particular two
worksheets to bring me the matching data - there are over 6,000 lines so I
really need to make it work.

I have part numbers that I ensured have no spaces at the end, one file came
from the ERA system so may have been different, but not I think they are both
'text'.
=VLOOKUP(A:A,Cdn!C:I,6,FALSE)

any suggestions?
thanks


Most likely, your data is not identical.

You should be able to "prove" this by formulas.

For example, if A1 contains a part number and Cdn!H7 contains the matching part
number, if they are identical then:

=A1=Cdn!H7 -- TRUE
=len(a1) = len(Cdn!H7) -- TRUE

etc.

The most common "invisible" character is an <nbsp CHAR(160) at the end of your
data.

--ron