Drop down list

[TwiggyB1]

I have a drop down box with a list of dates. On another worksheet I have 14 cells associated with each date. How can I make it so that when I select a date from the drop down list it will display the information in the 14 cells from the other worksheet? Hope this makes sense. Thank you in advance.

 

[pedie]

example:
Lets say your sheet2 has data & sheet has validation list in A1. B1 formula =vlookup(A1,Enter_Sheet2_DATa_range_here,1,0)

But i am still not sure how your data look like so...i think you have pretty fair idea how Vlookup, Lookup works.