Replace #N/A

Giganews Newsgroups
Subject: Replace #N/A
Posted by:  Ricki Miles (rickimil…@shaw.ca)
Date: Sun, 7 May 2006

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

Replies