Drop Down Menu Formulas

I have a worksheet that has a table with a list of drop down menus. Is there a way to add an IF formula to certain criteria depending on what is selected in the drop down menu choices above it?

For example, in my attached worksheet, I have 4 separate drop down menus (Player Universe, Scoring Format, Number of Teams & Number of Players per team) from which to choose from.

In the player universe menu I have three options, Mixed/AL/NL.
In the Number of Teams I have several different options ranging from 8-20.
In the Number of Players per team I have several different options as well ranging from 1-30.

I want all three of these menus to work together. If someone selects AL/NL from the player Universe menu and then selects 18 or 20 teams from the number of teams menu, then I only want the number of players per team menu to only allow up the 26 players instead of maximum 30. Is there anyway to do this?

Any help would be greatly appreciated, thanks!

Can anyone help?

On second thought, it works great for the AL/NL but when selecting MIXED for the player universe, you should still be able to select # of players up to 30, right now it's acting like the AL/NL only allowing a selection up to 26.

Originally Posted by FDibbins

I looked at the attachment, doesnt look like all the suggested formula was applied to your file

AceXL's post with the attachment uploaded works but only for AL/NL, when selecting Mixed & 18/20 teams, I would like the option to choose up to 30 players as opposed to only 26 if AL/NL was selected for 18 or 20 team choices. Hope that makes sense

Originally Posted by FDibbins

Did you look at the sample workbook I uploaded?

Yes, but I'm pretty confused, how many options would I need? Seems like a lot

Originally Posted by FDibbins

If you have 3 levels, and each level has 3 levels, you need 9 range names

Any chance you could insert what you're describing in my original attached worksheet?