Thanks GS & Faraz, the issue is reolved now.


"Faraz A. Qureshi" wrote in
message ...
If using XL 2007:
=IFERROR(VLOOKUP(....),"")
Otherwise
=IF(ISNA(VLOOKUP(....)),"",VLOOKUP(....))

--
Thanx in advance,
Best Regards,

Faraz


"Panchi" wrote:

I have a sheet that already has conditonal format where every 3rd row is
highlighted green (the cond. format formula is =MOD(ROW(),3)=1 ).

Now I want to add another condition where the #N/A is not visible. Its
OK
for all the rows that are not highlighted but it still shows the error in
the
rows still highlighted. how can i work around this?