In the sheet called "MONDAY PRACTICE" in cell B3 I am trying to create a drop down list. I want this list to be filtered down based on a couple of other criteria.
The first criteria is based on cell A3. Cell A3 is also a dropdown list that can include the following options: INSIDE RUN, TEAM RUN, 1/2 LINE, TEAM, SKELLY, 1/2 LINE SKELLY, SCREEN, TEAM PASS
If "INSIDE RUN", "TEAM RUN", "1/2 LINE" are selected in A3, then it should look at sheet "GAMEPLAN BOARD" and list data right-adjacent to cells reading "INSIDE RUN", "OFF-TACKLE RUN", "PERIMETER RUN"
If "SKELLY", "1/2 LINE SKELLY", "SCREEN", "TEAM PASS" are selected in A3, then it should look at sheet "GAMEPLAN BOARD" and list data right-adjacent to cells reading "SCREEN", "SPRINTOUT", "PLAY ACTION PASS", "QUICK GAME", "DROP BACK PASS"
If "TEAM" is selected in A3, then it should look at sheet "GAMEPLAN BOARD" and list data right-adjacent to ALL cells
I recognize what I am trying to do may not be possible, but I wanted to ask here once before giving up.
