Index formula help

[DarthBrute]

Please Login or Register  to view this content.

B1 refers to a month that is a named range. I want to type the month in and be able to pull data from a named range for that month based on the INDEX location.

I set up different named ranges to test which would be better:
DIV1OCT, DIV2OCT, DIV3JAN, etc..... (Format for named range is: DIV#MMM for OCT-JAN)

Also OCTOBER - DECEMBER that encompasses the entire area of OCTOBER, NOVEMBER, and DECEMBER. I figured I could either INDEX the individual DIV (Division) for a particular month or just INDEX an entire month.

I have attached the exact spreadsheet that I am trying to do this on and made notes as well. I don't know why I can't get it to work so any help would be appreciated.

[protonLeah]

C3:

Please Login or Register  to view this content.

[protonLeah]

Alternatively, using the name range: Div1Header ='TOTAL STATS M'!$A$4:$E$11

fill C3:L9 with:

Please Login or Register  to view this content.

[DarthBrute]

Wow. I didn't even know about that. Thanks proton! I just read up on that function. Thank you very much for the help.