Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 13, 2024
Lookup the Last Positive Value
The following formula returns the last positive value from B3:B10...
=XLOOKUP(TRUE,B3:B10>0,B3:B10,,,-1)
For earlier versions of Excel...
=LOOKUP(2,1/(B3:B10>0),B3:B10)
Based on the sample data, the formula returns 34.
Sample Workbook: Download