i need to be able to select a number from a drop down list based upon a value from another drop down list. My numbers are .25,.3,.35,.4,.5,.6,.8,1,1.2 that are in a drop down cell already, i have a cell next to it that has specific numbers that can be used per whatever number they selected. Example is if they select .3 they can only choose 50,75,100,125,150,175,200,225,250 in the second box. but for larger numbers like the 1.2 they can select only 150-500 in 25 increments.
Solved by E. W. in 25 mins