• 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.

Data Validation - Multiple Drop Downs

M

Martyn Pattison

New Member
Having sorted some issues out with my small project, I now wish to be able to select multiple information using Data Validation - Multiple Drop Downs. Whilst I can a simple approach right by selecting column 1 from a drop down and then further selecting column 2 based on Column 1 selection (using Indirect() function), I cannot get my head around to additional multiple drop downs based upon Column 1 selection.

I have tried to reflect what I am trying to achieve in attached file, which is part of my larger table I am building.

Any pointers would be gratefully received.

Many thanks
 

Attachments

  • Chandoo - Data Validation.xlsx
    12.7 KB · Views: 2
Columns are with letters.
Is Your sample file really something like Your small project?
Do it show all possible variations based Your sample ... given data?
Have You tried to do 'Search' from Chandoo.org?
... top right corner - search with Multiple Drop Downs
and You'll find many links.
 
You must log in or register to reply here.
Back
Top