surround your formula like this

=IF(ISERROR(formula),"",formula)
or
=IF(ISERROR(formula),"not in list",formula)

"Fletch" wrote:

My vlookup formual returns #N/A when there is not a match in my lookup table.
When there isn't a match, I would like the formula to return a balnk cell
rather than #N/A so that users don't think there are problems with the
formula. Any ideas?

Thanks