Selecting from Drop-down

  • Thread starter Thread starter bengaluru
  • Start date Start date
B

bengaluru

have a drop down menu with six numbers 1, 2, 3, 4, 5, and 6. what I am
trying to do is that if I select 1, it should give me a list of
different numbers in the subsequent rows.....similarly for the other
numbers. for Example if I choose 3 in my drop down menu (A 7), if
should automatically bring up the following numbers in cells A8 to A 13


15
25
30
47
52
61

Similarly the number should change when I choose 4 in the dop down menu
and likewise.

Hope I have made myself clear. How do I do that ????
 
One way...........
As long as you only need 6 numbers it can be done with a nested if-function.

enter in A8

=IF($A$7=1,E1,IF($A$7=2,F1,IF($A$7=3,G1,IF($A$7=4,H1,IF($A$7=5,I1,IF($A$7=6,J1,"none"))))))

enter the values you want returned when A7 = 1 in E1 to E6 and if A7 =2 in
F1 to F6
and so on to J1 to J6

so that you can change them if need be later on without having to change the
formula in A8
copy the formula down into A9 etc and it will pick up the cells E2 to J2
etc....
Have fun

Greetings from New Zealand
Bill K
 
Thanks Bill. I haven't tried it yet. will try it and let you know.

Bengaluru
Greetings from Toronto Canada
 
Back
Top