Lookup date in range depending on a number

**Ducatisto** · 05-05-2009, 05:47 AM

Hello,

I have a Master workbook with 4 sheets named WEEK 1 to WEEK 4. At work we work around 13 4 week periods and need this workbook to be dated accordingly, that is Period 1 Week 1 and date of first day (Sunday) of that period. The ideal solution would be for the user to enter 1 to 13 into a cell and via a button all dates to be populated and a new workbook created for that period. I have attached a sample workbook with the 4 weekly sheets and a date range on another sheet to show the range I need the dates from. I hope the workbook explains what I need better than my explanation here! If anyone can give me a few pointers I would be most grateful, many thanks.

**martindwilson** · 05-05-2009, 06:07 AM

try in d4 week 1
=CHOOSE(E2,Dates!C4,Dates!C5,Dates!C6,Dates!C7,Dates!C8,Dates!C9,Dates!C10,Dates!C11,Dates!C12,Dates!C13,Dates!C14,Dates!C15,Dates!C16)

**Ducatisto** · 05-05-2009, 07:21 AM

Originally Posted by martindwilson

try in d4 week 1
=CHOOSE(E2,Dates!C4,Dates!C5,Dates!C6,Dates!C7,Dates!C8,Dates!C9,Dates!C10,Dates!C11,Dates!C12,Dates!C13,Dates!C14,Dates!C15,Dates!C16)

Thank you for your reply, Excel seemed to find an error and prompted me to choose whether to correct it which I clicked yes and all was well, thank you.