View Single Post
  #1   Report Post  
dave
 
Posts: n/a
Default vlookup gives me a #N/A

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??