VLookup - Need Zero (0) Value Not #N/A When False

  • Thread starter Thread starter MIke
  • Start date Start date
M

MIke

Thank you in advance for consideration of my request.

I'm using a VLookup where the results are being summed. A
problem occurs when a False (#N/A) value is returned. I
would like the result of #N/A to actually be a 0 (zero).
I need this result without any additional manual
intervention (copy / paste special, find / replace, etc).
Can the VLookup statement be modified to accomplish this?
Adding in a column with some additional formula to
convert the #N/A to a 0 would be acceptable. I've tried
several to no avail.

Any suggestions?

Regards,

Mike
 
Hi Mike

you could try this

=IF(ISNA(your vlookup statement goes here),0,vlookup statement repeated
here)

Cheers
JulieD
 
Back
Top