Return Name of Winner for Select Category?

**paconsta** · 10-09-2012, 07:41 AM

I ranked the trucks based on their specs and they rank from 1 to 4. Now in G3 I want the name of the #1 ranked truck for the b2 category (G2 has the text "winner" in it. How do I do this?

How about a formula that adds up the points and selects a winner based on most points, and then displays the name of the winner?

**JosephP** · 10-09-2012, 08:09 AM

how about posting a workbook for testing instead of a picture? ;-)

**paconsta** · 10-09-2012, 08:21 AM

Good idea, I was thinking of that LOL

**JosephP** · 10-09-2012, 08:26 AM

if you want a winner for each row
g3: =INDEX($C$2:$F$2,MATCH(MAX($C3:$F3),$C3:$F3,0))
and copy down

do you get dental working for the mob? ;-)

**paconsta** · 10-09-2012, 08:39 AM

Thanks man! I knew it had to do something with INDEX MATCH just didn't know how to put it together. How did you know I work for the mob?

**JosephP** · 10-09-2012, 08:40 AM

it's in the file properties :-)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save