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

[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

 

[JulieD]

Hi Mike

you could try this

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

Cheers
JulieD

 

[Mike]

JuileD - THANK YOU! It worked.

Cheers / Good day,

Mike