Looking up the value corresponding to the last repetition in a ran

P

PaladinWhite

Essentially, I need to do a reverse-lookup; rather than finding the first
instance in a range, I need to find the last.

My ColA contains a list of twenty repeating names, and ColB contains a
number corresponding to each instance of a name. I'm trying to look up the
value in ColB corresponding to the last instance of a given name. For
instance, if my columns are such:

ColA | ColB
Bob | 1
Steve | 12
Mary | 41
Bob | 68
Mary | 3
Mary | 15
Steve | 72
Bob | 9

.... and I provide "Bob", I'd like to return the value 9; if I provide
"Mary", I'd like to return the value 15.

Thanks!

Cell C1 will hold the name I'm providing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min values in a list of numbers 1
Count Intervals of Filtered TEXT values in Column and Return Count across a Row 9
Recording the first change in the value of a cell 1
finding the largest number from the last row and look up its name. 5
IF column contains certain text return value of corresponding row 7
Conditional formatting to highlight the lowest valid value 1
Sumproduct but only first time corresponding value is seen e.g. un 1
How to perform lookups based on multiple criteria? 4

Top