3 level dependent drop-down list in excel

Hi,

Can somebody help me to create a dependent drop-down list as given in the attached example.


What i'm trying is to create:
1. drop down list for Category in first column (List as A and B as shown in the excel)
2. Against (1) Create drop-down of Dependent 1 in 2nd column. I.e, If I select “A“ in category, the drop down in 2nd column should display “D” and “E”. If I select “B“ in category, the drop-down in 2nd column should display “F” and “G”.
3. Against (2) Create drop-down in 3rd column as Dependent 2. . I.e, If I select “A“ and “D” respectively in column 1 and 2,the drop down in 3rd column should display “S” and “T”. If I select “B“ and “G” respectively in column 1 and 2,the drop down in 3rd column should display “Y” and “Z”

Kindly Help….
Thanks in advance…

Dear Ford,

Thank you very much for the quick support. The "Main type" and "Sub-type 1" is working fine,but the "Sub-type 2" is not displaying anything. Could you please check it once.

Once again thank you for the quick support.

Regards,
TJ

See attached using formulae provided Ford

Named ranges in Sheet2

Thank you John for the help.... It is working :-)

Hi All,

This is my first ever post so apologies if I am not following correct etiquette.

I am trying to solve a similar issue (dependent drop down lists) from the attached document.
when selecting category grass, I would like only those products in that category to show in the product dropdown menu and then only those item descriptions pertaining to the two previous drop down menus to show in the third drop down menu.

I hope this makes sense.

Thanks in advance

Thanks FDibbins!