Forum Discussion

ceray53's avatar
ceray53
Copper Contributor
Sep 07, 2023

Drop Down list column dynamic

Good morning all, I have a question and I am stumped.  So what I am attempting to do is when a div is changed (d) and also the corresponding month (f), then  I am wanting to have data placed in the green columns, that is not static and flows as the div and month change.  also, the div can remain the same, but as you change the month, the data from the green (and also blue) columns change with the corresponding month.  Is this hard to do, and also what is this called (I have spent days trying to find the right naming convention).

 

Thank you,

 

Charles 

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Sep 07, 2023
    it appears you are trying to do a LOOKUP function based on month and div from some master table/sheet. This could be accomplished using:
    XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, INDEX(MATCH()), FILTER(), etc
    but depends on the particular situation and I'm guessing in your case will require a bit more customization.
    if you have a sample workbook with no private information to share that would help.
    also, please confirm you have Excel 365 (or not) as that will be very important

Resources