Replace #N/A
 

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

Replace #N/A
 

=IF(ISNA(VLOOKUP(G8,D3:E6,2,FALSE)),0,VLOOKUP(G8,D 3:E6,2,FALSE))

Replace #N/A
 

That worked perfectly!!! Thank you so much!

"damorrison" wrote in message
ups.com...
=IF(ISNA(VLOOKUP(G8,D3:E6,2,FALSE)),0,VLOOKUP(G8,D 3:E6,2,FALSE))