I have this cell, H5, that returns #N/A when I think it should merely return a null. The cell it references is blank but does contain a formula. I’ve successfully been using IF(ref=""… to handle this up 'till now.
this is what’s happening. what am I doing wrong here?
in H5 =IF(L5="","",IF(B5="","",MATCH(L5,$A$1:A$30)+1)) #N/A
in L5 =IF(B5="","",(INDIRECT("A"&ROW()))-1) blank
in B5 03/02/2021
[Edit - Opaque] put code into preformatted textfortheweb.ods