One way:

=IF(ISERROR(yourVLOOKUPfunction),"",yourVLOOKUPfun ction)

This would make the cell look empty instead of showing the error. It would
not fix the error, though.

tj

"paula smith" wrote:

I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid
have some cells N/A instead of a number (zero). How I
could do that?
thanks in advance for your help,
Paula