I am using Excel 2003. I have created VLOOKUP formulas and some of the
results are #N/A because there is no such item in the list. I need to be
able to show this result.

I then need to subtotal the columns that contain some #N/A's, but the
subtotal command cannot recognize the error and include it in the subtotal.

Is there a way to use the VLOOKUP and tell it that if a match doesn't exist
to return a zero?

If not, is there a way to replace #N/A with a zero using the Find/Replace
feature?

Thanks in advance,

Ricki