Hello again Guys!

I am here again to ask for a formula: I have two columns. The first column is a set of letters with duplicates. I need to lookup or vlookup the second column but need to look for the last duplicate of the criteria being lookup.

Example: if i lookup for letter a using vlookup i should be getting the last cell in the column with letter a. So, ther answer should be 9.

a 3
b 2
a 1
c 6
c 8
d 5
a 9


I hope my example is clear.

Please help...

Thanks!