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!