Lookup the Last Text Value

Returning the Last Text Value

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

=LOOKUP(REPT("z",255),A2:A10)

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

Sample Workbook: Download