vlookup colums with reference to a formula from another sheet

[Guest]

I created a workbook that has individual sheets with 5 separate contestant
scores. The last sheet is a total page with point totals for each contestant
as a reference from their individual sheet in column 1 and the corresponding
contestant name in column 2. I am trying to use vlookup to view the data in
column 1 and return the corresponding name in column 2 in a cell of my
choosing. The total page looks like this: Please note that the values in
column A are references from calculations from other sheets.
A B
45 Brian
39 Alice
42 Tim
40 Jim
50 Ana

How can I use vlookup to show "Ana" as the winner in a cell of my choosing.

Hopefully someone can help.

Thx

 

[Biff]

Hi!

How can I use vlookup to show "Ana" as the winner

I assume Ana is the winner because she has the highest score?

=INDEX(B1:B5,MATCH(MAX(A1:A5),A1:A5,0))

Returns: Ana

In case of ties the first instance of MAX will be used:

45 Brian
50 Alice
42 Tim
40 Jim
50 Ana

=INDEX(B1:B5,MATCH(MAX(A1:A5),A1:A5,0))

Returns: Alice

Biff

 

[Guest]

Thank you the formula worked perfectly!!!!

Hi!


I assume Ana is the winner because she has the highest score?

=INDEX(B1:B5,MATCH(MAX(A1:A5),A1:A5,0))

Returns: Ana

In case of ties the first instance of MAX will be used:

45 Brian
50 Alice
42 Tim
40 Jim
50 Ana

=INDEX(B1:B5,MATCH(MAX(A1:A5),A1:A5,0))

Returns: Alice

Biff

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thank you the formula worked perfectly!!!!