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

Thomas Kuriakose

Active Member
Respected Sirs,

Good day to you.

I need your guidance on how to get three levels of dependent drop down in the cells marked in Validation tab from two separate lists in Data list tab. Kindly find attached the file for your reference.

The Segment should have Drop down from BS and BS1 in Data list Column A
The Product should have Drop down from PL and PL1 in Data list Column B based on selection of Segment
The Spec should have Drop down from CL,CL1, MCL,MCL1,AB List, AB List1 and CD List in Data list column C TO F based on the product selected.

Thank you very much for your kind support always,

with regards,
thomas
 

Attachments

  • Validation.xlsx
    14 KB · Views: 5
Hi Kuriakose,

Responding after a long time .....

You need to create named ranges and then use INDIRECT() to fetch data in those lists. See attachment, i hope it is working accurately.
 

Attachments

  • Reworked_Validation.xlsx
    15.5 KB · Views: 5
Respected Sir,

Nice to see you back, thank you so much for this solution and it works perfectly.

i used INDIRECT() without the named ranges. new learning everyday.

Thanks once again,

Much appreciated,

with regards,
thomas
 
Back
Top