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?