complicated drop down menu question

D

Don Doan

Hi there,
Perhaps someone can help me with this issue, it's a bit long so bear with me.
I have 2 spreadsheets, the first one is called data, the second one is
called summary
On the data sheet, I have it lay out as a sample like below, in different
columns, all in text format

week 1 Jan 1 Jan 2 Jan 3 Jan 4
week 2 Jan 8 Jan 9 Jan 10 Jan 11
week 3 Jan 17 Jan 18 Jan 19

On the summary sheet, I'd like to have a drop down menu on cell A1 that
should have the week number as my choices, and then as I select the week
number, the date will show up on a set of cells and change accordingly as I
select a different week on the drop down menu.

Thanks for all your help
 
P

Paul C

Assign the range with week 1, week 2, etc.. a name (like WeekNo).

You can then use this name as the Data Validation list source. Simply put
=WeekNo in the source box. This allows you to reference a range on another
sheet.

The just use a VLookup to return your dates
=Vlookup(A1,DataSheet!$A$1:$H$52,2,false)
(Change the DataSheet to whatever your sheet name is, adjust the range as
needed)

If your selected week 1 in cell A1 this would return Jan 1 from your sample
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top