formula help for a beginner´?

[verdandi]

I have managed to figure out everything i was supposed to learn except for one thing.


let's say I have 2 columns, A and B

column A contains names and coulumn B contains their ages. now I need a formula that finds the highest age, and who it is.


this is too hard for a girl like me especially when everything is in english..


<3

 

[Hui]

<3

Try this:

=+INDEX(A1:A20,MATCH(MAX(B1:B20),B1:B20,0))

Adjust Column heights to suit