Excel 2007

[Roozle]

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]

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

I don't understand the second question.