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