Lookup the Last Non-Zero Value

Returning the Last Non-Zero Value

The following formula returns the last non-zero value from A2:A10...

=LOOKUP(2,1/(A2:A10<>0),A2:A10)

Based on the sample data, the formula returns 2.

Sample Workbook: Download