I want to run this Excel formula:
=IFERROR(INDEX(Y163:AA163,MATCH(TRUE,Y163:AA163<>"",0)),"")
But ONLY if the formula in cell B163 produces a result/value.
I've tried different formulas but cell X163 still produces a value even though B163's formula has not produced a value.
Example formulas I've tried:
=IFERROR(IF(LEN(B163)<>"",(INDEX(Y163:AA163,MATCH(TRUE,Y163:AA163<>"",0)),""),"")
=IFERROR(IF(B163<>0,(INDEX(Y163:AA163,MATCH(TRUE,Y163:AA163<>"",0)),""),"")
In other words, I want a formula in X163 that states that if B163's formula results in a value or is not equal to 0, then run the formula beginning with "INDEX." On top of this, put this all in an IFERROR statement, because that's what I do with all my formulas. So there are a lot of nested formulas/statements.
How can I get this new condition to override other conditions?
Aucun commentaire:
Enregistrer un commentaire