• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dependent Drop Down Lists

madocar

Member
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
 

Attachments

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
 

Attachments

Back
Top