Drop Down Box to change cell values

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hi there,
I want to have a drop down list to change the values in a
column

for example if a1=Package1 then

a2=$495
a3=$45
a3=3.75%
a4=$0.45

by changing a1=Package2 than

a2=$199
a3=$45
a3=4%
a4=$1.00

Thanks a lot for your help
 
Jordan, select cell A1 go to data validation in the allow box pick list in
the source box put Package1,Package2
then in A2 put = IF($A$1="Package1",495,IF($A$1="Package2",199,"")) in your
example you gave 2 A3 cells if you meant A3, A4, A5 then just copy the
formula down and replace the 495 and 199 with the valves you want for that
cell, format the cells as needed. now you will have a drop down box in A1
with Package1 and Package2 to chouse from and the data in the other cells
will change with it

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Jordan,

First you need a data table with the products and values in columns like

G H I J K
Package1 495 45 3,75 0,45
Package2 199 45 4,00 1,00

Then you can use VLOOKUP() in cells A2-A5 to get the values from the data table corresponding to the product in A1.

For the drop down list, you can use Data>Validation with the first column in the data range as list input.

HTH
Anders Silven
 
Jordan

In cells E5 to A13 I created a table
E5 To E13 is Package_1 To Package_9
Te Values of A2 to a5 are filled in columns F to I

I named the range E5 to e13 "Package" (without the quotes)

I selected cell A1, went to data, Validation, selected List and put in
"=Package" (without quotes)

In cells A2 to A5 formulas of the form:
=VLOOKUP($A$1,$E$5:$F$13,2,FALSE)

Is this what you were after?
Alan
 
Back
Top