where value is not in row one, how do I return a value of zero instead of #N/A
S Sandy Oct 26, 2004 #1 where value is not in row one, how do I return a value of zero instead of #N/A
G Govind Oct 26, 2004 #2 Hi Sandy, Use =IF(ISERROR(YOUR HLOOKUP FORMULA),0,YOUR HLOOKUP FORMULA) Regards Govind.
