'Looking' across a row to return a value

[LWendell]

Hi - I'm trying to develop a formula that will look across 17 columns of data and return the first value that is greater than zero. I tried using embedded 'if' statements but the 17 columns exceed the number of 'ifs' I'm allowed.

Any suggestions would be appreciated!

 

[Aladin Akyurek]

Hi - I'm trying to develop a formula that will look across 17 columns of data and return the first value that is greater than zero. I tried using embedded 'if' statements but the 17 columns exceed the number of 'ifs' I'm allowed.

Any suggestions would be appreciated!

Control+shift+enter, not just enter...

=INDEX(A2:Q2,MATCH(1,IF(ISNUMBER(A2:Q2),IF(A2:Q2 > 0,1)),0))

 

[LWendell]

Thank you!