Returning row number from Maximum value

[KeithMJ]

This is the basic layout of what I have:-

A B C D E F
1Week Name Prod #1 Prod #2 Prod #3 Total units
2 26/03/11 Keith 10 8 10 28
3 Brian 10 10 7 27
4 Karen 0 21 4 25
5 Andrew 5 16 2 23
6 Chris 8 12 4 24

I'm using =SUM(C2:E2) to add up the individual sales in F, and then using =MAX(F2:F6) to find the highest number (28 in this instance). What I would like to do is have a way of getting the Row number where the highest number is so that I can retrieve the name in that row. I want to display it something like this:- "28 units were sold by Keith this week".
Obviously, I wouldn't need something like that on a sheet this small, but imagine it containing thousands of cells.

Thank you for any help you can offer.
Keith.

[ChemistB]

To aid in future searches, this site requires relevant titles. In your case maybe "Returning row number from Maximum value" See these rules to avoid further issues;

http://www.excelforum.com/forum-rule...rum-rules.html

Thanks.

[day92]

Keith - welcome to the forum, you can do a combination of index/match or a vlookup to get the results you are looking for, I would recommend uploading some sample in a spreadsheet.

[NBVC]

day92, please refrain from responding to threads where a Moderator or senior member has asked the OP to adhere to forum rules, until that issue has been resolved.

[KeithMJ]

To aid in future searches, this site requires relevant titles. In your case maybe "Returning row number from Maximum value" See these rules to avoid further issues;

http://www.excelforum.com/forum-rule...rum-rules.html

Thanks.

My apologies. I just wanted to dive straight in with a question and I would have put a title like that if I had known just what it was I needed to do. As I said, I'm new to Excel so please bear with me.

[ChemistB]

Try
=INDEX($B$2:$B$6,MATCH(MAX($F$2:$F$6),$F$2:$F$6,0))
Does that work for you?

[KeithMJ]

Thank you, ChemistB. A bit of fiddling and it worked as I wanted it to. Your reputation has been added to