I'm using the above formula to return a blank cell or a 0 if my vlookup
returns an N/A. Where this is a problem is that I have a forumlua
=vlookup(A1,range,6,false)-I1. When I use
=IF(ISNA(vlookup(A1,range,6,false)),"0",(vlookup(A 1,range,6,false))-I9 I get
#VALUE! instead of 0. Why? Is there anyway around that? I'm trying to
automate my sheet as much as possible so that I don't have to spend time
deleting formulas etc...