Lists and alternate cell return

[MikeinOK]

I want to be able to choose a list, then a date, and return a value in an adjacent cell.


I wanted to make a "named " group with each set of dates, so that I could make the named group auto grow if more dates were added but was unable to get my drop down list show the population of the named group.

So then I manually put in name of lists, and setup the dates to pull a range based on name in list cell C15.

I tried using Offset and Indirect to gather sales but kept getting #ref, but I am iffy on my knoweldge of using them effectively at times.

=OFFSET(INDIRECT(C17),0,1)

Thanks, Mike

[Ace_XL]

In C19

=INDEX(INDEX($C$4:$G$12,,MATCH(C15,$C$3:$G$3,0)+1),MATCH(C17,INDEX($C$4:$G$12,,MATCH(C15,$C$3:$G$3,0)),0))

[MikeinOK]

Thank you very much