Hi Steve

=IF(ISNA(your_formula),"",your_formula)

--
Regards
Roger Govier
"Steve )" <Steve
wrote in message
...
I'm using the VLOOKUP function to lookup inventory in our database. How
can
I set up the formula so that the #N/A will display 0 instead. I went to a
seminar and the instructor did this but I did not get to write the formula
down.