vlookup colums with reference to a formula from another sheet
 

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

vlookup colums with reference to a formula from another sheet
 

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

"AK" wrote in message
...
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

vlookup colums with reference to a formula from another sheet
 

Thank you the formula worked perfectly!!!!

"Biff" wrote:

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

"AK" wrote in message
...
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

vlookup colums with reference to a formula from another sheet
 

You're welcome. Thanks for the feedback!

Biff

"AK" wrote in message
...
Thank you the formula worked perfectly!!!!

"Biff" wrote:

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

"AK" wrote in message
...
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