Hello. I’m trying to create a sorting table in excel using drop down menus. For example, column A has a list of college programs. Column B has a list of states and column C has a list of colleges.
If I select Master’s Program in Column A for example, it will only give me a partial list of the correct states in column B where those programs are available. If I then select one of states it will give me another choice in column C to show if that program is available.
I can build the drop down menus I just don’t know what formulas I need to link the information together.
Any help is appreciated.
If I select Master’s Program in Column A for example, it will only give me a partial list of the correct states in column B where those programs are available. If I then select one of states it will give me another choice in column C to show if that program is available.
I can build the drop down menus I just don’t know what formulas I need to link the information together.
Any help is appreciated.
