ISBLANK and OR Function
 

Try the below array formula

=IF(COUNTIF($S$5:$BY$5,"0")=COLUMNS($S$5:$BY$5)," None",INDEX($S$4:$BY$4,MATCH(0,VALUE($S$5:$BY$5),0 )))

If this post helps click Yes
---------------
Jacob Skaria


"Bec G (Oz)" wrote:

I have the formula below which I am using to find the first blank cell in a
row and return the header of that row but I've now been told that the cell
might be blank or might be zero and we want the header returned

=IF(COUNTA(S5:BY5)=0,"None!",INDEX($S$4:$BY$4,MATC H(TRUE,ISBLANK(S5:BY5),0)))

Any ideas on how to amend this to work?

Thanks