ISBLANK and OR Function
 

Try the below and feedback

=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 )))

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

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