Dependent Drop Down Lists

[madocar]

Hello everyone,

I would like to ask you to help me solve my problem about Dependent Drop Down Lists. What I need is:

Column B - selected values from drop down list from column H = no problem

Column C - I want to choose products according to value in cell B2, B3, B4 ...

I did it by marking the range according the name of customer and then Data Values >> List >> Indirect(B2).

Things is I don't know the name of the customer so far.

Hope I describe my problem understandable

Thanks for any help, more in attachment

 

[prasaddn]

Hi

As you do not know the customers name, give pseudo names to each customers products, like ProductsCust1, ProductsCust2 etc

and use data validation in Column C, with Indirect("ProductsCust" & match(B2....))
See the example:
=INDIRECT("ProductsCust"&(MATCH(B2,$H$1:$H$8,0)-1))

With this, without knowing the name of customer, based on the row number listed in H column, you can get products listed.

attached is your updated excel file.

Regards,
Prasad DN

 

[madocar]

Amazing solution !!
Thanks a lot prasaddn