Hi,

Try

=VLOOKUP(A1,Cdn!C:I,6,)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


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