Index and match help

[bluefeather8989]

i need a formula that will find the top 9 and display the name next to it
Example:

A B
2 AA
4 BB
9 CC
9 DD
1 EE


answer would be CC

 

[dave3009]

You could do that with VLOOKUP, try

=VLOOKUP(9, $A$1:$B$5, 2, 0)

 

[bluefeather8989]

i need a formula that will find the top 9 and display the name next to it
Example:

A B
2 AA
4 BB
9 CC
9 DD
1 EE


answer would be CC

oops i made a mistake. it should be the other way around
Example:

A B
AA 2
BB 4
CC 9
DD 9
EE 1

sry about the mix up

 

[dave3009]

In that case, try...

=INDEX($A$1:$A$5, MATCH(9, $B$1:$B$5, 0))

 

[bluefeather8989]

In that case, try...

=INDEX($A$1:$A$5, MATCH(9, $B$1:$B$5, 0))

YAY it works! thanks and cheers