General syntax when you have a formula (your_formula) that may return a #N/A
error and you want nothing returned rather than #N/A

=IF(ISNA(your_formula),"",your_formula)

Regards
Ken.......................




"israel" wrote in message
...
Thank you for your prompt reply, but I am a bit confused. I should point
out,
my result vlookup column is L2:L385. I assume your formula should be
applied once I have the result ffrom "vlookup", in "conditional
formating".
Please advise.

Thank you

--
smile


"Gord Dibben" wrote:

Example of using ISNA rather than ISERROR which hides all errors.

=IF(ISNA(VLOOKUP(G1,$A$1:$F$31,2,FALSE)),"",VLOOKU P(G1,$A$1:$F$31,2,FALSE))


Gord Dibben MS Excel MVP


On Thu, 7 May 2009 09:26:02 -0700, israel

wrote:

Hello all you wonderfulhelp,

Is it possible to avoid "NA" when using "vlookup" function. I need info
only where
it brings results.

Thank you