excelenergy
Board Regular
- Joined
- Jun 7, 2012
- Messages
- 142
Hello,</SPAN>
I attached a document...Thanks for your time in advance....
My question is this...Im unfamilar with how to do dynamic drop downs based on look-upped up values in Excel. So let me explain what I mean...when you open my document, on the userform there are two categories “Category 1” and “Category 2” – based on the two selections from those drop downs I want Excel to populate a third drop down called “Category 3”, but I want it to populate the third drop down with the "Number, and Colour" that corresponds to the combination selected in the first two drop downs. So all the look up values are on “Sheet2”...I know the vlookup formula but how do I get Excel to populate a third drop down with a colour, and number value - based on the values from the two above drop downs above it? </SPAN>
(It it is of any value, these are the different combinations for the different colours), but you can see these values in a chart by opening the attachment and selecting “sheet2”:
http://www.filedropper.com/inputtemplate-sampledata
These combinations would make the third drop down populate green
C1 and L1, or L2, or L3, or L4,
C2 and L1, or L2, or L3
C3 and L1, or L2
C1 and L1
These combinations would make it populate orange:
C2 and L6
C3 and L5
C4 and L4
C5 and L3
C6 and L2
These combinations for yellow:
C1 and L5
C1 and L6
C2 and L4
C2 and L5
C3 and L3
C3 and L4
C4 and L2
C4 and L3
C5 and L1
C5 and L2
C6 and L1
These combinations to populate the colour red:
C3 and L6
C4 and L5
C4 and L6
C5 and L4
C5 and L5
C5 and L6
C6 and L3
C6 and L4
C6 and L5
C6 and L6</SPAN></SPAN>
I attached a document...Thanks for your time in advance....
My question is this...Im unfamilar with how to do dynamic drop downs based on look-upped up values in Excel. So let me explain what I mean...when you open my document, on the userform there are two categories “Category 1” and “Category 2” – based on the two selections from those drop downs I want Excel to populate a third drop down called “Category 3”, but I want it to populate the third drop down with the "Number, and Colour" that corresponds to the combination selected in the first two drop downs. So all the look up values are on “Sheet2”...I know the vlookup formula but how do I get Excel to populate a third drop down with a colour, and number value - based on the values from the two above drop downs above it? </SPAN>
(It it is of any value, these are the different combinations for the different colours), but you can see these values in a chart by opening the attachment and selecting “sheet2”:
http://www.filedropper.com/inputtemplate-sampledata
These combinations would make the third drop down populate green
C1 and L1, or L2, or L3, or L4,
C2 and L1, or L2, or L3
C3 and L1, or L2
C1 and L1
These combinations would make it populate orange:
C2 and L6
C3 and L5
C4 and L4
C5 and L3
C6 and L2
These combinations for yellow:
C1 and L5
C1 and L6
C2 and L4
C2 and L5
C3 and L3
C3 and L4
C4 and L2
C4 and L3
C5 and L1
C5 and L2
C6 and L1
These combinations to populate the colour red:
C3 and L6
C4 and L5
C4 and L6
C5 and L4
C5 and L5
C5 and L6
C6 and L3
C6 and L4
C6 and L5
C6 and L6</SPAN></SPAN>