Return the Last Value

Returning the Last Value

The following formula returns the last value, whether numerical or text, from A2:A10...

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

Based on the sample data, the formula returns "C".

Sample Workbook: Download