CLASSIFICATION | DROP-DOWN MENUS |
C | drop-down menu C |
B | drop-down menu B |
A | drop-down menu A |
C | drop-down menu C |
B | drop-down menu B |
Hi,
I am trying to make different dropdown menus depending on the classification cell that is right next to it. So, for instance, if I have classification "D", I want to have a drop down menu for D. I was thinking of making the different lists on a different spreadsheet for each classification... but then once I do that, how do I set it so that whenever there is C in cell A2, for instance, I want to have ONLY the drop down list for A... Does anyone have any idea how to do that?