Dependent validation

[Thomas Kuriakose]

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

 

[Faseeh]

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.

 

[Thomas Kuriakose]

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