Changing options based on selected value from a drop down

Hello all,

I have a certain value in column C: Type of Network. From this, the end user is asked to pick (from a list) either open loop, closed loop, filtered loop or flexi loop. I'm fine with the data validation of the cell (in column D)
What I am trying to do is to have an automated pop up list enabled only if the user chooses either filtered loop or closed loop in Column D. The pop up would then ask the user to choose either MID or MCC. These options would not be available if the user had selected open loop.

Does this make sense? I have no idea how to start

thank youuuuu

C.

Start by searching for "dependent drop down lists" and come back if you get stuck.