Multiple Row selection through dropdown

[amandeep16]

Hi everyone,

I have an excel sheet in which column A is having Defect and column B is having category, column C consist of causes and column D consists of remedies.I need to have that when I select defect from dropdown 1 and category from dropdown2 , corrsponding cause and remedies will appear in dropdown for further selection.

Please help me out!!


Thanks & Regards
Amandeep Singh

[JohnTopley]

See here ...

http://www.contextures.com/xlDataVal02.html

[JohnTopley]

See attached.

I have made a number of named ranges (See "Formulas" ==> "Name manager")

There are two dynamic Named Ranges in " Master": "DV_Causes" and "DV_Remedies" which created based on the Selections in "Defect" Category"

"DV_Causes"

=IFERROR(INDEX($C$2:$C$13,SMALL(IF(($A$2:$A$13='Selection sheet'!$A$3)*($B$2:$B$13='Selection sheet'!$B$3),ROW($A$2:$A$13)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

"DV_Remedies"

=IFERROR(INDEX($D$2:$D$13,SMALL(IF(($A$2:$A$13='Selection sheet'!$A$3)*($B$2:$B$13='Selection sheet'!$B$3),ROW($A$2:$A$13)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

The dropdowns use the same format in Data Validation:

Allow: List

Source: = NamedRange (as appropriate)