If no result is found, how can I have this function return "0" instead of "#N/A"? Thanks, Bill Allen
B Bill Allen Apr 7, 2006 #1 If no result is found, how can I have this function return "0" instead of "#N/A"? Thanks, Bill Allen
H Harlan Grove Apr 7, 2006 #2 Bill Allen wrote... If no result is found, how can I have this function return "0" instead of "#N/A"? Click to expand... =IF(ISNA(MATCH(...)),0,MATCH(...))
Bill Allen wrote... If no result is found, how can I have this function return "0" instead of "#N/A"? Click to expand... =IF(ISNA(MATCH(...)),0,MATCH(...))
