Creating multiple dropdown lists for one cell in google sheets?

user_16523859 0
Viewed 53

As always I like to fully disclose I'm not advanced at this stuff, so please forgive my ignorance.

I'm wondering if there is a way to have a cell in google sheets have multiple dropdown lists depending on the selection of another cell?

I.e, IF C14 = [X] then I13 will = one drop down list. But if C14 = [Y] then I13 will = another dropdown list variation.

I was thinking the VLOOKUP tool but this doesn't seem to work. Would I need to create a script?

Any help is greatly appreciated,

Josh

google-sheets-formula google-sheets excel
2 Answers
user_150193800

Create a new sheet to determine which list should be applicable

Sheet List:

List List X List Y
=ARRAYFORMULA(IF('Moderate Deficit'!I14="X",B2:B,IF('Moderate Deficit'!I14="Y",C2:C,))) X1 Y1
X2 Y2
Y3

Set the drop-down list range to be from List!A2:A

user_161251390
Related