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