View Single Post
  #4   Report Post  
KL
 
Posts: n/a
Default

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.