Excel 2007
 

How can I use a drop down menu to display a answer in a different cell, with
each answer differing depending on what was selected from the drop down menu.
I would also appreciate if I could find out how to do it with text also.

Thanks

Excel 2007
 

Debra Dalgleish shows how to use dependent lists with data|validation he
http://contextures.com/xlDataVal02.html

I don't understand the second question.

Roozle wrote:

How can I use a drop down menu to display a answer in a different cell, with
each answer differing depending on what was selected from the drop down menu.
I would also appreciate if I could find out how to do it with text also.

Thanks

--

Dave Peterson