kinkart
Member
Hello,
I have been pulling my hair for a while with this, so hopefully someone can help.
here's my setup:
tab "MASTER"
Starting in A2 and down, I have a list of unique ID
In C2 and down, primary colors
In D2 and down, secondary colors
In E2 and down, tertiary colors
In F2 and down, quaternary colors
Colors can be spread out across columns, but the same color is never on the same row.
tab "DASHBOARD"
I have a dropdown list in C2, listing all the colors used in "MASTER" columns C/D/E/F.
What I'd like:
When I select a unique color from the dropdown list in C2, D2 creates a list in a dropdown menu listing all the unique ID that have that color, in either "MASTER" C, D, E or F.
Using INDEX MATCH in D2, I can return the first value in the cell. But how can I have it display ALL the matches, in a drop down list (using data validation - list)?
I have been pulling my hair for a while with this, so hopefully someone can help.
here's my setup:
tab "MASTER"
Starting in A2 and down, I have a list of unique ID
In C2 and down, primary colors
In D2 and down, secondary colors
In E2 and down, tertiary colors
In F2 and down, quaternary colors
Colors can be spread out across columns, but the same color is never on the same row.
tab "DASHBOARD"
I have a dropdown list in C2, listing all the colors used in "MASTER" columns C/D/E/F.
What I'd like:
When I select a unique color from the dropdown list in C2, D2 creates a list in a dropdown menu listing all the unique ID that have that color, in either "MASTER" C, D, E or F.
Using INDEX MATCH in D2, I can return the first value in the cell. But how can I have it display ALL the matches, in a drop down list (using data validation - list)?
