Vlookup problem

[Tracey]

Has anyone come across a problem where a vlookup returns
#N/A when the lookup value definitly exists?

I have two workbooks called "Demand" and "Part" and the
formula is:
=VLOOKUP(A2,[part.xls]MatchCode!$A$1:$E$1528,5,0)

The "demand" file has been created by a VBA macro whereas
the "Part" file has been created by an ODBC query. so I
suspect that there are formatting differences between the
two sheets, because if I manually re-enter the lookup
value into its own cell then the lookup works ok.

I have tried copying and over-pasting the cells as values,
and chanigng the cell formatting to general, text or
numbers, but that doesnt help.

Andy ideas?

 

[Tracey]

I have sussed it out. There were leading spaces in the
cell i was trying to lookup up
thanks anyway
Tracey

 

[YAN]

try to use formula =value(source cell), instead of paste it as value