Need to make a drop down list of 3 items that input a value in ano

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

solarflare - 14 Mar 2008 21:23 GMT

I have a savings calculator that i am working on. we have three products
that i would like the user to be able to select from. basis their selection
from the drop down list, i would like a corresponding value to go into a
certain cell.
how do i do this???

Reply to this Message

Tom Hutchins - 14 Mar 2008 22:28 GMT

To create the dropdown list:
- select the cell where you want it to appear
- select Validation from the Data menu
- choose List
- you can either type in the list of items, separated by commas, or use the
grid button next to the textbox to select a range of cells that has the list
of products
- click OK

To populate the other cell (say, E5) based on the dropdown cell:
- enter a formula similar to the following in E5
=IF(D5="AA",100,IF(D5="BB",200,IF(D5="CC",300,0)))

In this example, the products are AA, BB, and CC. The dropdown list is in
cell D5. The corresponding amounts are 100 for AA, 200 for BB, and 300 for CC.

Hope this helps,

Hutch

> I have a savings calculator that i am working on. we have three products
> that i would like the user to be able to select from. basis their selection
> from the drop down list, i would like a corresponding value to go into a
> certain cell.
> how do i do this???

Reply to this Message

Debra Dalgleish - 14 Mar 2008 23:58 GMT

You can use data validation to create the dropdown list, and a VLookup
formula to fill in the corresponding value. There are instructions and a
sample file here:

http://www.contextures.com/xlOrderForm01.html

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rate this thread: