|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
Thanks in advance,