Confused with Drop Down Menus

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

--
Message posted from http://www.ExcelForum.com

Dave
Sun Jun 20 07:51:14 CDT 2004

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.)

"Evil_Dragon <" wrote:
>
> 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 I
> select something a price appears in another cell, however all I get is
> a number refering to the selection of the drop down menu. I have
> looked at stuff like Macros, and lookups but havnt have any luck using
> them for what I need.
>
> Any suggestions deeply apprieciated.
>
> ---
> Message posted from http://www.ExcelForum.com/

--

Dave Peterson
ec35720@msn.com

andrez
Sun Jun 20 07:54:42 CDT 2004

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
Evil_Dragon wrote:
> *I need to create a worksheet for some coursework that create
> invoices, quotes etc. for companys. I wanted to used drop down menu
> so when I select something a price appears in another cell, howeve
> all I get is a number refering to the selection of the drop dow
> menu. I have looked at stuff like Macros, and lookups but havnt hav
> any luck using them for what I need.
>
> Any suggestions deeply apprieciated.

--
Message posted from http://www.ExcelForum.com