Drop down menu

A

alen_re

Hi !

I need to make a dropdown menu..
In attachement I have two columns..

I want to make dropdown menu in B1.. and to choose between options B2 -
B16.. and when I make a choice.. I want my choice te show up in E1 (from
B column) and F1 (from D column)

Thanks a lot


+-------------------------------------------------------------------+
|Filename: quest 1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4256 |
+-------------------------------------------------------------------+
 
G

Guest

data validation(allow list) or combo box from from toolbar.depending on what
you want to show in your second output(F1) use a lookup or choose,index etc
to .People wont always use your attatchment(it didnt work btw),describe in
your post what you have/want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Drop Down Menu 2
Drop Down choice needs to lead to another drop down menu 1
SUMIF problemwith 2 column range 3
creating nested formulas from drop down box 5
help with formula please 7
Copying a Drop Down Menu 2
Autofill until blank cell is reached 7
Drop downs list on every line for a specific column? 3

Top