Cell Validation - Drop Down Lists and Text Formatting

Hi,    I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/c...