Have you taken into account this remark for VLOOKUP function:

When searching number or date values, ensure that the data in the first
column of table_array is not stored as text values. In this case, VLOOKUP
might return an incorrect or unexpected value.
?


"Missile" wrote in message
...
When using this formula =IF(ISBLANK(B2,"",VLOOKUP(B2,D2:E20,2,1)) I am
getting the #N/A error or incorrect data if the value in cell B2 starts
with
a 0 eg 07934.
Any suggestions as to fix this?

Thanks