Data dependent on date

[smbridges]

Good Morning,

I have an excel spreadsheet where I input certain data per week and for each additional week I have to create a new sheet. I was wondering how could I make it where I could have a drop down of the date and then enter my numbers for the week and it save the numbers I enter and I can refer back to them by using the drop down.

Make sense?

 

[oldbrewer]

Week of:

Apr-23

dates

Apr-23

Apr-24

Apr-25

Apr-26

Apr-27

Apr-28

Apr-29

days

MONDAY

TUESDAY

WEDNESDAY

THURSDAY

FRIDAY

SATURDAY

SUNDAY

Daily

6

25

MPA

2

24

DTM

1

23

#

1

22

date required

Apr-24

< < , K15

Daily

25

MPA

24

DTM

23

#

22

formula finding the 6

=OFFSET($A$3,MATCH(F23,$A$4:$A$7,0),MATCH($K$15,$B$2:$H$2,0))

<colgroup><col span="3"><col><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>

 

[smbridges]

Ok, so I copied and pasted what you had into excel and Apr-24 ended up at K15 so I knew that was good. The formula is coming up with 25 and from what I'm reading above it should be 6, right?
So from top left down is how my cells are laid out.

A2 >> dates
A3 >> days
A4 >> daily
A5 >> MPA
A6 >> DTM
A7 >> #
_____

B2:H2>>Apr23:Apr-29

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

I typed the date into K15

remember for testing purposes I selected Apr-24 so 25 is correct (tuesday not monday)

 

[smbridges]

Ok, now I see how it works!
Ok so lets say I want it to list each number from Daily - #. Would I need a different formula for each one?

ALSO is there a way to have the drop down of my dates and when i select the date it auto populates the numbers? What if it's a new date and I haven't manually imputed the numbers yet there?
Sorry I'm brain storming and my brain storming has reached the max of my excel knowledge.

 

[oldbrewer]

not sure what "list each number from Daily - # " means

ok to have a drop down - it is the same as typing a specific date in

if a new date you will get zeros or an error message