On Thu, 13 Oct 2005 07:26:01 -0700, "dave"
wrote:

When I try to look with vlookup for a value that is not in the table
indicated, I get the message #N/A which indicates that the value cannot be
found (this is normal).

I would like to change this message #N/A into a value 0 or a blanc ""
because you cannot calculate with this value.

Is this possible??

Just wrap your vlookup in an If statement. i.e.

If(isna(vlookup(blah_blah)),0,vlookup(blah_blah))

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________