Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 13, 2024
Lookup the First Positive Value
The following formula returns the first positive value from B3:B10...
=XLOOKUP(TRUE,B3:B10>0,B3:B10)
For earlier versions of Excel...
=INDEX(B3:B10,MATCH(TRUE,B3:B10>0,0))
Note that the formula needs to be confirmed with CTRL+SHIFT+ENTER. If done correctly, Excel will automatically place curly braces {...} around the formula.
Based on the sample data, the formula returns 92.
Sample Workbook: Download