# Easy search question

#### Barbapapa

##### New Member
Hello,

My problem will most likely be very simple to solve, but I can't figure out anything atm...

I have data as follows

........A..............B.............C......................H..........I
1....name 1....name 2.....name 3....etc...max....winner
2......30...........28..............50.................50
3......60...........11..............27.................60
4 ...

What should I put on the column I so I it shows the winner based on the max result?

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
If there's only 1 winner, then maybe:

=INDEX(\$A\$1:\$G\$1,Match(H2,A2:G2,0))

Richard

Thanks,

Works great.

Replies
2
Views
431
Replies
8
Views
2K
Replies
13
Views
672
Replies
2
Views
395
Replies
1
Views
120

1,219,671
Messages
6,149,613
Members
450,904
Latest member
Gracifer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back