formulas in drop down lists
 

I have a form in an Excel spreadsheet with several drop down lists. The lists
are on a separate worksheet. Several of the lists are made up of formulas.
However, when I use the form and choose from the list, only the answer goes
into the box on the form. I would like the formula to go into the form
instead. Is there a way to do this?