try
IF(ISNA(yourformula)),0,yourformula)
or
IF(ISNA(yourformula)),"",yourformula)

--
Don Guillett
SalesAid Software

"Jennifer" wrote in message
...
Good day, I have a quick question. When using a vertical lookup that
looks
at a named table for the returned values, if the item is not present in
the
table it returns an N/A. Is there any way to have it return a zero (0) if
it
is not present in the table?