How to Make Column B Selections dependent on Column A Selection
Apologies for the confusing title, I'm too naive to know exactly how to describe this. Essentially what I need to do is make a drop-down list for two different columns where the second depends on the first. Say I have a table like this:
| Drink | Brand/Type |
|---|---|
| Soda | Coke, Diet Coke, Sprite, Pepsi, Diet Pepsi, Mountain Dew |
| Water | Dasani, Fuji |
| Wine | Red, White |
| Sparkling Water | Waterloo, Sanpellegrino, Spindrift |
I want the first column's choice to affect what you can choose in the second column. I currently have Data Validation lists for both columns separately so even when I choose 'Soda' in Column A, then Column B has all of the Brand/Types listed including things like 'Dasani' and 'White' or 'Red' wine. When I select Soda in Column A, I only want the list of sodas to be available in Column B.
Hope this makes sense. I imagine this should be easy enough to do, but I can't seem to figure it out because I'm an idiot lol.
[link] [comments]
Want to read more?
Check out the full article on the original site