Lookup the Last Numerical Value

Returning the Last Numerical Value

The following formula returns the last numerical value from A2:A10...

=LOOKUP(9.99999999999999E+307,A2:A10)

Based on the sample data, the formula returns 4.

Sample Workbook: Download