Excelman122
New member
- Joined
- Feb 1, 2018
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi - please can you assist with the below scenario
I want a cell to show me multiple values I can pick based on the value in another cell based on a master table.
Master table example
Apple > red
Apple > blue
Apple > green
Apple > purple
Banana > red
Banana > black
Banana > white
So cell A1 has Apple and therefore the options I want to see in cell A2as a dropdown would be red, blue, green, purple based on the master table
Additionally if cell A1 was updated to banana I want it to now show me the available values in A2 - red,
Black and white?
I want a cell to show me multiple values I can pick based on the value in another cell based on a master table.
Master table example
Apple > red
Apple > blue
Apple > green
Apple > purple
Banana > red
Banana > black
Banana > white
So cell A1 has Apple and therefore the options I want to see in cell A2as a dropdown would be red, blue, green, purple based on the master table
Additionally if cell A1 was updated to banana I want it to now show me the available values in A2 - red,
Black and white?