Fantasy football Manager of the month

**Nathaniel82** · 04-02-2009, 08:33 AM

Good afternoon,

I run a Fantasy football league at work and for next season i have decided to introduce a manager of the month system.

This is how i did it:-

First, i made =sum formulas for every four week period for each team.

Then i linked the cells to my "Manager of the month awards" page into a table with monthly columns from august to april, and alphabetised rows with team names in them.

This resulted in having each teams score per month.

My problem is that i can't make a formula that "looks up" the highest value for any given month, and that returns the team name for that value to me.

If anyone could help me out i would be very grateful, i have tried Vlookup, Hlookup, lookup and columns and all sorts of things but i cant find anything that does this for me.

**NBVC** · 04-02-2009, 09:01 AM

Can you post a sample workbook showing where the data is and what kind of input/output you want

**Nathaniel82** · 04-02-2009, 09:08 AM

How do i put it in here on the forum???

**NBVC** · 04-02-2009, 09:10 AM

When you Reply to a thread you will see a paperclip icon in the Reply Box.. click and then add a .xls or .zip file.

**Nathaniel82** · 04-02-2009, 09:32 AM

Ok, here goes,

i have only sent one sheet when in fact i have 13, but the formulas will be replicated to the remaining sheets.

On the sheet i have attached, in column N there are four weekly scores set up.

i want these scores linked to a new sheet that i have, called "Manager of the month awards" to a table that can work out the maximum monthly score out of all 13 teams, and the tell me the team name related to that score.

**NBVC** · 04-02-2009, 09:36 AM

It would be nice to the setup and some sample results in the "Manager of the month awards" sheet too. Include sample entries in the first sheet and what you want to see in the results sheet.

**Nathaniel82** · 04-02-2009, 10:21 AM

This is what i have for you now.

There are three sheets with sample data in them spanning three months.

on the Manager of the month sheet i have written some notes for you to look at.

Thanks for all your help so far though!!!!

**NBVC** · 04-02-2009, 10:26 AM

Try this in I25:

=INDIRECT("'"&INDEX($C$9:$C$11,MATCH($H$9,D$9:D$11,0))&"'!A1")

**Nathaniel82** · 04-02-2009, 10:41 AM

looks ok on that one i sent to you, will let you know when i've applied it to the whole thing.

Thank you very much.

this has been doing me in for two days!!!!

**Nathaniel82** · 04-02-2009, 11:13 AM

Woo hoo!!!!!!! It works!!!! I cant believe it!!!! Thank you soooooooo much!!!!!

Excellent info rate.....

1 question - 1 Answer!!!!

Exceptional work!!!

**NBVC** · 04-02-2009, 11:16 AM

Most of the time it is easiest if you provide detailed examples... you will almost guarantee solutions that will work sooner rather than later due to confusion and back and forth questioning....

Glad it worked!