Restrained Values

[STRATIUS]

Hi could any one help me out with this:
There are two cells that have drop down menus. How do I retrain the 2nd drop down menu depending on the first? Example:
1st drop down menu returns the values GLC and GL should someone choose GL the 2nd drop down menu will range from 0-2,5. How can I restrain the range of the 2nd dropdown to 0-1 if the choice is GLC?.

PLease help

[swatsp0p]

Let's assume your first dropdown is in C1. Create two lists in G1:G6 with your values from 0 to 2.5 and a second in H1:H2 with values of 0 and 1 (of course, adjust ranges and values to meet your needs)

Then in D1, Select List in the Validation box and enter this formula in the Source line:

=IF(C1="GL",$G$1:$G$6,H1:H2)

A choice of GL in C1 will give the choices in column G, anything else will give the choices in col. H

To not offer choices if C1 is blank (or any other value), try this:

=IF(C1="GL",$G$1:$G$6,IF(C1="GLC",H1:H2,""))

HTH

Bruce