Drop down list options dependent on cell value  
Author Message
DaveMillerM3





PostPosted: Wed Mar 12 15:57:18 CDT 2008 Top

Excel Misc >> Drop down list options dependent on cell value

i would like a cell to be able to have 3 possible drop down lists depending
what the value of another cell is. Is this possible?

e.g. If cell c3 = 1 then i want cell c4 to have a drop down list displaying
1,2,3,4
but if cell c3 = 2 then i want cell c4 to have a drop down list displaying
5,6,7,8

i have tried to figure out an if statemet but can't. help!!!

Excel26  
 
 
Conan





PostPosted: Wed Mar 12 15:57:18 CDT 2008 Top

Excel Misc >> Drop down list options dependent on cell value MT,

http://www.contextures.com/xlDataVal02.html

HTH,

Conan






>i would like a cell to be able to have 3 possible drop down lists depending
> what the value of another cell is. Is this possible?
>
> e.g. If cell c3 = 1 then i want cell c4 to have a drop down list
> displaying
> 1,2,3,4
> but if cell c3 = 2 then i want cell c4 to have a drop down list
> displaying
> 5,6,7,8
>
> i have tried to figure out an if statemet but can't. help!!!


 
 
John





PostPosted: Wed Mar 12 15:59:02 CDT 2008 Top

Excel Misc >> Drop down list options dependent on cell value Hi,
(For Excel 2003) Put the numbers 1 to 8 in cell A1 to A8, then click into
cell C4>Data>Validation>select from list and put
=IF($C$3=1,$A$1:$A$4,$A$5:$A$8) as the source.

This will work if you put 1 in cell C3 showing 1 to 4 in the dropdown list,
and will show 4 to 8 for any other number in cell C3.

You need to consider what you want to show if the number in cell C3 is not a
1 or 2 and either change the above formula or put validation on on cell C3.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)




> i would like a cell to be able to have 3 possible drop down lists depending
> what the value of another cell is. Is this possible?
>
> e.g. If cell c3 = 1 then i want cell c4 to have a drop down list displaying
> 1,2,3,4
> but if cell c3 = 2 then i want cell c4 to have a drop down list displaying
> 5,6,7,8
>
> i have tried to figure out an if statemet but can't. help!!!