Validation Box error with "over the limit" Nested IF Statements

Hello, I am seeking some help with a rather complicated validation box. I am using a combination of 3 “over the limit” nested IF statements. If I substitute arbitrary values instead of ranges (used for the validation box), the If Statements work as expected. It’s when I try to use these in my validation box with ranges instead of values when the error occurs. So, on the Level Up worksheet, the yellow boxes S11:V11 show the working If Statements that use arbitrary values used to test the formulas. Cells P11:R11 show what my formula needs to be for the validation box (and for which I have Named Formulas, called AbilityIncreaseFormula4a, 4b and 4c. The Validation Boxes’ final destinations are in cells D7:I7. So, if you check the cell D7, you will see that my validation box is generating an error, as the conditions are such that it should be offering you a list to select either a “1” or “2”.

Once these have been 100% completed, I will then need to make separate Named Formulas for each row, through to row 23. So, I will eventually have 51 (17x3) unique formulas. I am VBA-challenged, so I am trying to do everything with formulae. Feel free to suggest an easier or more efficient way to accomplish my end goals. I’m not sure VLOOKUP and/or INDEX/Match will work because every class’s limitations are unique. Here’s what I’m trying to accomplish in a nutshell:

When you reach a new level, you first choose a new class (cell c7 in this test case). IF that level brings you to 4th level in that class (or at later levels, it can be many other permutations, as shown in my long formulas), AND you did not choose a Feat (in cell K7), THEN you can select from a list a value of either 1 or 2 to add to one cell in the range D7:I7…but if you select 2, then it disables (yielding a blank list) all the other cells in that range…and if you select a value of 1, then the validation boxes only give you an option to select a value of 1 (which then disables the other cells in that range). Basically, you can add a maximum of 2 points total in cells D7:I7, and rather than let the user put these values in themselves, I am attempting to put some error-checking in place to prevent going over this maximum (and ensuring they qualify based upon their class chosen AND class level in that particular class).

I told you it was complicated.  I know many of you dwarf my excel knowledge, so I’m hoping for some simplification or suggestions that can make this work. I don’t get why my IF Statements work, but not the validation. Thank you so much for your time!

I solved this by using vlookup instead, and it works (and much more efficiently) without the need for tons of formulas. Thanks to whomever spent any time reading this or looking at my spreadsheet.