So I'll try explaining this the best I can of what exactly it is I need...

Lets say I have my first Column with Data Validation giving me the choices A,B,C and D.

I then made a second column using IF functions within data validation so that for each choice A,B,C or D...they each have a seperate numeric list to choose from (1 to whatever #)...so you have something along the lines of 1-4 selectable with A, 1-2 selectable with B, 1-5 selectable with C, and 1-3 selectable with D.

Now heres where it gets tricky and I need some insight. I need the third column to be based off the first two columns with a default value that shows, but with a selectable list in case the default isn't whats desirable.

For example:

If I choose A in the first column, and 1 in the second column...the third column gives me a default value of W, but I want to be able to also select with a list in that cell between W,X,Y and Z as well.

Any thought?

I can give a little more clarification or go more in depth if needed.

-Thanks