Creating multiple dropdown lists for one cell in google sheets?

Question

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

Answer 1

You should post your own sheet, otherwise take a copy ofhttps://docs.google.com/spreadsheets/d/1IDifehV68cEGlI1pqpvNLEnReZRLnyiZf-4ipFl-E3s/copy