+ Reply to Thread
Results 1 to 3 of 3

Selecting from Drop-down

  1. #1
    Forum Contributor bengaluru's Avatar
    Join Date
    06-10-2005
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    150

    Selecting from Drop-down

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

  2. #2
    Bill Kuunders
    Guest

    Re: Selecting from Drop-down

    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


    "bengaluru" <[email protected]> wrote
    in message news:[email protected]...
    >
    > 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 ????
    >
    >
    > --
    > bengaluru
    > ------------------------------------------------------------------------
    > bengaluru's Profile:
    > http://www.excelforum.com/member.php...o&userid=24188
    > View this thread: http://www.excelforum.com/showthread...hreadid=378223
    >




  3. #3
    Forum Contributor bengaluru's Avatar
    Join Date
    06-10-2005
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    150
    Thanks Bill. I haven't tried it yet. will try it and let you know.

    Bengaluru
    Greetings from Toronto Canada

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1