Confused with Drop Down Menus

  • Thread starter Thread starter Evil_Dragon
  • Start date Start date
E

Evil_Dragon

I need to create a worksheet for some coursework that creates invoices
quotes etc. for companys. I wanted to used drop down menus so when
select something a price appears in another cell, however all I get i
a number refering to the selection of the drop down menu. I hav
looked at stuff like Macros, and lookups but havnt have any luck usin
them for what I need.

Any suggestions deeply apprieciated
 
It sounds like you used the dropdown from the Forms toolbar.

If your input range is A1:A10 and your linked cell is B1, you could use a
formula like:

=if(b1="","",index(a1:a10,b1))

But you may find working with Data|Validation even simpler.
For lots of nice notes, visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

And if you used the combobox from the Control Toolbox toolbar, you'd see that
the linked cell contained the actual value.

(I find Data|Validation the simplest.)
 
Hi

just use these numbers which you describes as "refering to th
selection of the drop down menu" as an indicators in CHOOSE functio
e.g. CHOOSE(B100,C100:C200)
where B100 - cell which contains changing numbers from your drop-dow
menu (DDM) and C100:C200 - array that contains values for your DDM (o
prices or whatever you want to be displayed after selecting somethin
in your DDM)

good luck
 
Back
Top