drop down menus

[jw73]

i am trying to construct a drop down list that when a particular value is selected, it changes a corresponding cell in the same row.

example A1= value of x changes cell f1 and g1 to x

i know how to create the drop down but dont know how to make it change other cells

i have poured thru other forums and couldnt find the answer so i thought i would just put the question out there

any help is greatly appreciated

 

[T. Valko]

i am trying to construct a drop down list that when a particular value is selected, it changes a corresponding cell in the same row.

example A1= value of x changes cell f1 and g1 to x

i know how to create the drop down but dont know how to make it change other cells

i have poured thru other forums and couldnt find the answer so i thought i would just put the question out there

any help is greatly appreciated

If you have a drop down list in cell A1 and want other cells to show the same value that's selected from the drop down, then:

In cells F1 and G1 enter this formula:

=A1

 

[jw73]

T. thanks for quick response

here is the issue and maybe you can expand

the list i am compiling is made up of about 100 values

example rewards1= 1.95% $.35
example corp data2= 2.25% $ .25

so when i pick rewards 1 in drop down it needs to change cells g1 and h1

does that make sense?

 

[T. Valko]

T. thanks for quick response

here is the issue and maybe you can expand

the list i am compiling is made up of about 100 values

example rewards1= 1.95% $.35
example corp data2= 2.25% $ .25

so when i pick rewards 1 in drop down it needs to change cells g1 and h1

does that make sense?

See if this helps...

http://contextures.com/xlFunctions02.html