Just some thoughts ..

I was unable to replicate the formula here in xl97
with the sheetname: 'Projekt en C27materiaal prijslijst'
as it exceeded the limit of 31 chars !

So, not sure whether this (sheetname error?) could have contributed to the
prob. Perhaps a quick re-check and re-input of the sheetname would be a good
idea ..
(note that spaces also count in the 31 chars limit)

If that's not it, you could also try something along the lines of:

=VLOOKUP(TEXT(A27,"000"),'Projekt en C27'!A:C,3,0)

The above assumes the ref table's sheetname is: Projekt en C27 and assumes
the lookup value in A27 is a real number, while the ref values in col A in
sheet: Projekt en C27 are 3 digit "text" numbers
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Rochelle" wrote in message
...
Hello! I have an excel sheet with a VLOOKUP function that looks like this:
=VLOOKUP(A27;'Projekt en C27materiaal prijslijst'!A:C;3;0)
and the idea is that by typing in the look-up value the following 4
columns
would be populated by data from the list. What happens is that unless the
initial code is sought, copied and pasted from the source worksheet, all I
get is #N/A. This seems to go contrary to the purpose of the VLOOKUP.
I need to be able to type in the code and not to have to search for it and
to paste it in. What am I doing wrong?
I have considered that perhaps the cell formats of the codes or the fact
that some are numbers and others are numbers and text may make a
difference,
but it returns #N/A anyway. Any suggestions?