Max wrote:
One way, array-entered* in say, C1:
=INDEX($B$1:$B$10,MATCH(MAX(IF($A$1:$A$10="A",ROW( $A$1:$A$10))),IF($A$1:$A$10="A",ROW($A$1:$A$10)),0 ))

*press CTRL+SHIFT+ENTER to confirm the formula

Adapt the ranges to suit

Assumin that the list in A1:B5, if the functions in the
freelydownloadable file at http://home.pacbell.net/beban are available
to your workbook

=INDEX(VLookups("A",a1:b5,2),2)

Alan Beban