Hi -- I was wondering if someone might be able to help me real quick :)


I have a drop down list in Cells B4:B9

In Cell B7 they can choose between 2 options
In Cell B9 they can choose between 5 options but if they choose in Cell B7
for example Option 1 then cell B9 can only have Site selected but if they
choose Option 2 in Cell B7 then they choose from the remainder of the list (5
choices) Is this possible?
Thanks!

List the items available to B9 in a range of cells and list Site as the
first itme.

J1 = Site
J2 = item2
J3 = item3
J4 = item4
J5 = item5

Then, as the source for the drop down in B9 use this formula:

=IF($B$7="option 1",$J$1,$J$1:$J$5)

--
Biff
Microsoft Excel MVP


"H" wrote in message
...
Hi -- I was wondering if someone might be able to help me real quick :)


I have a drop down list in Cells B4:B9

In Cell B7 they can choose between 2 options
In Cell B9 they can choose between 5 options but if they choose in Cell B7
for example Option 1 then cell B9 can only have Site selected but if they
choose Option 2 in Cell B7 then they choose from the remainder of the list
(5
choices) Is this possible?
Thanks!

Here is one way

Suppose your choices in B7 are Option1 and Option2, and your list of five
items is in G1:G5:

Site
Item1
Item2
Item3
Item4

Name cell G1 Option1, name the range G2:G5 Option2. You do this by
selecting the range you want to name and typing the name into the Name Box on
the left side of the Formula Bar and pressing Enter.

In cell B9 set your Data, Validation to List under Allows and enter the
formula
=INDIRECT(B7)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"H" wrote:

Hi -- I was wondering if someone might be able to help me real quick :)


I have a drop down list in Cells B4:B9

In Cell B7 they can choose between 2 options
In Cell B9 they can choose between 5 options but if they choose in Cell B7
for example Option 1 then cell B9 can only have Site selected but if they
choose Option 2 in Cell B7 then they choose from the remainder of the list (5
choices) Is this possible?
Thanks!

So

It's totally possible!
Basically you want the second selection to be based of the first drop-down.
This website may help: http://www.contextures.com/xlDataVal13.html




"H" wrote:

Hi -- I was wondering if someone might be able to help me real quick :)


I have a drop down list in Cells B4:B9

In Cell B7 they can choose between 2 options
In Cell B9 they can choose between 5 options but if they choose in Cell B7
for example Option 1 then cell B9 can only have Site selected but if they
choose Option 2 in Cell B7 then they choose from the remainder of the list (5
choices) Is this possible?
Thanks!