Replace #N/A

[Ricki Miles]

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

 

[damorrison]

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

 

[Ricki Miles]

That worked perfectly!!! Thank you so much!