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

[solarflare]

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???

 

[Tom Hutchins]

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

 

[Debra Dalgleish]

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