Hi,
I am familiar and comfortable using Drop Down Lists for data input accuracy. But now I'm in a situation where I'd like to set the drop down list to be dependent on the value in another cell:
E.G. if A1 = SUB, then value picked in the dorp down list in cell B1 uses list in are c1:c20, if A1 = INT, use area d1:d20 for B1, if A1 <> INT and A1 <> SUB, use list in area e1:e20 for cell B1
Is this even possible?
Basically, I have sort of a waterfall effect, where if you pick SUB in cell A1, there are only certain options you can pick for B1.
Thank you,
Tiina
I am familiar and comfortable using Drop Down Lists for data input accuracy. But now I'm in a situation where I'd like to set the drop down list to be dependent on the value in another cell:
E.G. if A1 = SUB, then value picked in the dorp down list in cell B1 uses list in are c1:c20, if A1 = INT, use area d1:d20 for B1, if A1 <> INT and A1 <> SUB, use list in area e1:e20 for cell B1
Is this even possible?
Basically, I have sort of a waterfall effect, where if you pick SUB in cell A1, there are only certain options you can pick for B1.
Thank you,
Tiina
