Data Validation based on Optional Inputs
 

John Calder

Take a look here, if I understand you correctly this might help.

http://www.contextures.com/excelfiles.html#DataVal

Mike Rogers

"John Calder" wrote:

Hi

I run W2K with Excel 2K.

What I have is a data validation down box which has 2 options. Lets say in
cell B8 and the are called "Selection 1" and "Selection 2"

Then I have 2nd data validation box (lets say B11) which takes its
information from a range name (which is in a different worksheet) Lets say
the range name is called "Range 1"

Now here is the problem, I have a second list in a separate worksheet which
is defined by a range name called "Range 2"

I would like the 2nd drop down box to be based on one of the "TWO" range
names, depending on which selection is taken in the 1st drop down box.

Is this possible?

I tried putting the formula "IF($B$8="Selection 1","Range 1","Range 2") in
the validation data source box but this did not work. I also tried it without
the inverted commas for Range 1 and Range 2 but it still did not work.

Any help would be much appreciated

John