If statement with Data Validation

[PondWaters]

I have a spreadsheet that I am having a bit of an issue with. I have data validation for a few columns, but only certain ones should auto populate, others you will still have the option of a dropdown. For example, I would want it so that if one chooses pepsi as the initial dropdown it automatically fills out Soft Drink and Yes.
If someone chooses water it gives the data validation for type of drink and then for fizzy.
If Powerade Energy drink - no
Orange Juice would let you choose for Type and for fizzy say no.


Is this possible without VBA? Below is an example of the spreadsheet.

Excel Workbook
	A	B	C
2	Drink	Type	Fizzy
3
4
5
6
7
8
9
10
11
12
Sheet1

This is the data tab:

Excel Workbook
	A	B	C	D	E
1	Gatorade		Soft Drink		Yes
2	Water		Energy Drink		No
3	Pepsi		Juice
4	Coke		Other
5	Mr. Pibb
6	Orange Juice
Data

 

[PondWaters]

Bump.