ctjacobs2010
Board Regular
- Joined
- Dec 12, 2013
- Messages
- 56
In cell A1 I have a dropdown menu of the numbers 1-5.
-For B2 I am wanting if A1 equals 3,4,5 then B2 is blank
-If A1 equals 2 then I want B2 to be a dropdown option with the the word "Select" and "VAC"
-If A1 equals 1 then I want B2 to be a dropdown that says "Select", "VAC", "SICK", "BRVMT", and "JURY"
I have tried multiple ways but cant figure out how to make this work or if it is even possible.
Please Help,
Ctjacobs2010
-For B2 I am wanting if A1 equals 3,4,5 then B2 is blank
-If A1 equals 2 then I want B2 to be a dropdown option with the the word "Select" and "VAC"
-If A1 equals 1 then I want B2 to be a dropdown that says "Select", "VAC", "SICK", "BRVMT", and "JURY"
I have tried multiple ways but cant figure out how to make this work or if it is even possible.
Please Help,
Ctjacobs2010