How to copy text when selecting an option from a drop down list.

[Emma1]

Hi,

I have a drop down list of 15 options each saying 'Weekend Period 1', 'Weekend Period 2' etc. Further to the left on the same sheet i have information under each of them titles.

I want to be able to select any of the 15 options on the drop down list and the text under the title which is further to the left to be copied over.


Any ideas on how to do this??