Drop down menus

[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

 

[AB]

Is the dropdown in a cell (validation) or on a userform?

Maybe this isn't what you need but still:
ad a List validation (Data>Validation>List) to cell A1. Put in the
'Source' for the validation this:
1,2,3
or
1;2;3 (depending on your regional settings)
Then in the A1 ther will be a drop down lettin you enter either 1 or 2
or 3
then in B1 put formula:
=CHOOSE(A1;"One";"Two";"Three")
or
=CHOOSE(A1,"One","Two","Three")

Change the value in A1 and see how B1 changes.

I'm not sure if it was what you're after, though.

 

[Patrick Molloy]

I don't understand the request. If its data validation take a look at this
demo

http://cid-b8e56c9a5f311cb7.skydriv...el Files/Data Validation/Data|_Validation.xls

maybe it will give you a pointer