How do you change which drop down menu appears dependent on entry in another cell?

On the attached sheet, what I am wanting to do is have two different menu's appear in cell M9, dependent on what is chosen from the drop down menu in cell N4

Basically, if someone chooses AA from Cell N4, i want the drop down menu in cell M9 to only show one option, "Without Legs"

Whereas if someone chooses AB up to AJ in cell N4, then i want the drop down menu in cell M9 to show all 3 options, "With Legs", "Without Legs", and "Face Fix".

Anyone got any idea if this can be done or not plz, and if it can, how?

thanks!

Two named ranges:

S5:S7 is "All_opt"

S6: "Without_Legs"

DV in M9

List

Source:

=IF($N$4="AA",Without_Legs,All_Opt)

thats it! thank you very much, a big help that! :D