select random item from a drop down list in excel

I have an Excel sheet with cells that can be filled only with items from the dropdown list and I want to fill it randomly

many of the solutions on the web select a random value from a list (not a dropdown list) this does not work for me because my drop-down lists are dependent on other cells so they change based on them what i want is to randomly select items from each new dropdown list