xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Lookup the Last Value Regardless of Data Type

Lookup the Last Value Regardless of Data Type

The following formula returns the last value from B2:B10...

=LOOKUP(2,1/(B2:B10<>""),B2:B10)

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



spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes