T
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?
#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?
