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?
My personal Web Excel Tutorials
Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
Also for a decimal number I use a comma (,) you may need to use point (.) instead of
Bookmarks