#N/A

thanks bob..that did it..thanks for taking time to help
-----Original Message-----
Steve,

=IF(ISNA(vlookup_formula),0,vlookup_formula)

--

HTH

Bob Phillips

"steve" wrote in message
...
when using the vlookup function i receive '#N/A',
which i
expect. Unfortunately, i need it to return a '0'
(zero),
because its the first in a series of calculations that
are linked to other sheets. but once i recieve
the '#N/A', all calculations stop. Is their anyway to
have a cell return a value of '0' or just blank,
instead
of '#N/A'.
thanks
steve


.