Yes that IS my ERROR

--

HTH

Bob

"????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message
...
It looks like: ISERROR but sounds like: IFERROR
Isn't it ?
Micky


"Bob Phillips" wrote:

=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


.