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