=IF(ISNA(vlookup_formula),"",vlookup_formula)

If you have Excel 2007

=IF(ISERROR(vlookup_formula),"")

--

HTH

Bob

"Rechie" wrote in message
...
I am using vlookup but some results are #n/a. How can i avoid it so that my
sum formula will not show #n/a.

Thanks

Rechie