Using Formula to activate a dropdown menu

Hi,

I want to use an IF formula to activate a drop down menu, so

If the drop down menu in column A says X i'd like column B to have the dropdown menu that relates to X, is this possible and if so how?

Thanks very much

Pete