I have a table as follows in a 2nd worksheet
In the main worksheet I have Cell B2 as List that allows you to choose 4-128 no problem
Cell B1 is the number of computers
IF B1 <= 4 B2 would display all options
Now the tricky part:
IF B1 =>5 I would like to have only 8 thru 128 available to display
IF B1 =>9 then only 16 thru 128 display
I have been playing with nested IF Statements but not sure if this is the correct way or my syntax is off.