Drop down list options dependent on cell value

[mt]

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

 

[Conan Kelly]

MT,

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

HTH,

Conan

 

[John]

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)