Different dropdown lists based on one cell value

[ines.serodio]

Hi,
I want cell A to display a dropdown list. (that's done). I want cell B to display a dropdown list based on cell A value (so far so good). I want cell C to display a dropdown list based cell A value. I'm not able to use indirect function because it show's up cell B drop down list. IF formulas are not working as well. Dependent lists also do not work because they are not single value. Any solution?

Thank you

IS

[JBeaucaire]

It might get lengthy if there are a LOT of possible options in the column A drop down, but you can use IF/THEN formulas in the DV Source to select drop down lists if you give them NAME RANGES.

Let's say your lists on a sheet called LISTS. In column A you have the source for you first main drop down. In each of the following columns you have additional drop down lists, and you highlight each one and give them a name in the NAME MANAGER.

Let's say columns B C and D have named ranges List1, List2 and List3.

For your DV source formula in column C that is looking at column A, something like:
=IF($A1="Cat", List1, IF($A1="Dog", List2, IF($A1="Bird", List3)))

Hopefully that will send you down a usable road.

[Roel Jongman]

Hi Ines,

I think we can help you a lot better if you post an example file, please look at the yellowbanner at the top of the screen on how to upload a file what it should look like.

I will try to explain in words without example..
I think you can use Indirect function but you may need to add a little part to it make unique references for B and C

so lets say col A has Apples, Banana, Orange and you pick Banana.

then you use INDIRECT(A2) to get the Banana options

but if you use INDIRECT(A2)&"B" and INDIRECT(A2)&"C" and you make the columnheaders "BananaB" and "BananaC" then you can make different dropdown lists based on the same Col A value

[ines.serodio]

Tried both ways but no results. excell attached

[JeteMc]

Attached is the file with Roel's proposal employed.
Let us know if you have any questions.