Lookup the Last Instance of a Value and Return the Corresponding Value
The following formula searches A2:A10 for the last instance of the value in D2, and returns the corresponding value from B2:B10...
=LOOKUP(2,1/(A2:A10=D2),B2:B10)
Based on the sample data, the formula returns 80.
Sample Workbook: Download