F
flavjunior
I am trying to set up table to return a value and a text statement using
VLOOKUP, but I do not know how to break a "tie" and show 2 different text
statements. Here is what I'm getting:
My data list:
Score Name
4 Johnny
6 Bob
7 Scott
6 Lewis
I want to make a table that ranks by highest value and displays the
corresponding name in the next column. I am using LARGE to sort the Score
and VLOOKUP to show the name. Here is what I get:
Rank Score Name
1 7 Scott
2 6 Bob
3 6 Bob
4 4 Johnny
How do I display all names? VLOOKUP just returns the first Name closest to
the top of the list that it sees. I would the table to show this:
Rank Score Name
1 7 Scott
2 6 Bob
3 6 Lewis
4 4 Johnny
VLOOKUP, but I do not know how to break a "tie" and show 2 different text
statements. Here is what I'm getting:
My data list:
Score Name
4 Johnny
6 Bob
7 Scott
6 Lewis
I want to make a table that ranks by highest value and displays the
corresponding name in the next column. I am using LARGE to sort the Score
and VLOOKUP to show the name. Here is what I get:
Rank Score Name
1 7 Scott
2 6 Bob
3 6 Bob
4 4 Johnny
How do I display all names? VLOOKUP just returns the first Name closest to
the top of the list that it sees. I would the table to show this:
Rank Score Name
1 7 Scott
2 6 Bob
3 6 Lewis
4 4 Johnny