Results 1 to 10 of 10

Drop down multi-cell propogation

This is a discussion on Drop down multi-cell propogation within the Excel Questions forums, part of the Question Forums category; I'm trying to propagate multiple cells underneath a drop down on "another sheet", so when you choose a selection it ...

  1. #1
    New Member
    Join Date
    Apr 2017
    Posts
    9

    Default Drop down multi-cell propogation

    I'm trying to propagate multiple cells underneath a drop down on "another sheet", so when you choose a selection it places the list of numbers underneath it in the same format as it is in my table.

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Drop down multi-cell propogation

    please show us a small example

  3. #3
    New Member
    Join Date
    Apr 2017
    Posts
    9

    Default Re: Drop down multi-cell propogation

    Rate Schedule: TOU-GS-2-B (drob down)
    Rates
    Winter Mid
    Winter Off
    Summer On
    Summer Mid
    Summer Off
    (Space)
    Non-time Demand
    Summer On Demand
    Summer Mid Demand
    Customer Charge

    (Rate Schedules)

    Rates TOU-GS-1-A TOU-GS-1-B TOU-GS-2-A
    Winter Mid 0.14251 0.10479 0.07173
    Winter Off 0.13357 0.07556 0.06157
    Summer On 0.20994 0.14733 0.33751
    Summer Mid 0.17197 0.07343 0.11185
    Summer Off 0.14671 0.05521 0.05502
    Column1
    Non-time Demand 9.74 15.48
    Summer On Demand 6.47
    Summer Mid Demand 2.46
    Customer Charge 24.77 24.77 220.3

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Drop down multi-cell propogation

    so if you select winter mid there is no match for tou-gs-2-b ?

  5. #5
    New Member
    Join Date
    Apr 2017
    Posts
    9

    Default Re: Drop down multi-cell propogation

    Quote Originally Posted by oldbrewer View Post
    so if you select winter mid there is no match for tou-gs-2-b ?
    Negative.

  6. #6
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Drop down multi-cell propogation

    the single word negative does not help us to help you....

  7. #7
    New Member
    Join Date
    Apr 2017
    Posts
    9

    Default Re: Drop down multi-cell propogation

    Quote Originally Posted by oldbrewer View Post
    the single word negative does not help us to help you....
    It does not, it displays NA.

  8. #8
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Drop down multi-cell propogation

    post 5 just says negative. Where is the NA - or am I losing the plot ?

  9. #9
    New Member
    Join Date
    Apr 2017
    Posts
    9

    Default Re: Drop down multi-cell propogation

    Quote Originally Posted by oldbrewer View Post
    post 5 just says negative. Where is the NA - or am I losing the plot ?
    My fault, I tried:

    =INDEX(tbl_items[Winter Mid],MATCH(B1,tbl_items[itemnum],0))

    And got NA.

    See I forgot youre not a mind reader...



    Or are you?!?!?

  10. #10
    Board Regular
    Join Date
    Apr 2010
    Posts
    8,941

    Default Re: Drop down multi-cell propogation

    try something where you know there will be a successful match for test purposes

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com