hi, Im having exactly the same problem with my vlookups

Using your formula (without the =signs) gets rid of the #N/a but returns
zero for cells which did have figures in

This is the formula I used

=IF(ISNA(VLOOKUP($B3,HrsMon,2,FALSE)),"",VLOOKUP($ B3,HrsMon,2,FALSE))

Can you help?

Cheers


"KL" wrote in message
...
sorry, remove the equal signs inside the formula.

KL


"KL" wrote in message
...
=IF(ISNA(=VLOOKUP(I3;marke****ch;1;0)),"",=VLOOKUP (I3;marke****ch;1;0))

Regards,
KL


"carl" wrote in message
...
I use this formula:

=VLOOKUP(I3;marke****ch;1;FALSE)

Can it be modified to not return #N/A ?

Thank you in advance.