drop down list

H

H

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!
 
T

T. Valko

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)
 
S

Shane Devenshire

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top