Data Validation List based on criteria

[Tiina]

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

 

[Scott T]

This video will show you how to do dependent data validation


https://youtu.be/-78bH0RZ7MA

 

[Tiina]

Thank you! this looks to be exactly what I was looking for. I just didn't know to google "dependent data validation" Thank you as always!

 

[Scott T]

You're welcome