Dependent Drop Down List

[msharma864512]

I want to create a dependent dropdown list:

First list should be made from column C, in the dropdown list it should only show unique values
Second dropdown should be dependent on 1st dropdown, so for e.g from the 1st drop down I selected, HPC, then in the second dropdown it should only show companies list from HPC sector.

Additionally, Instead of just selecting from the dropdown list, one should also have the flexibility to write the desired name, so for e.g. if anybody start Typing H in the sector dropdown, it should show all the list name containing "H"

Regards,
Manish

 

[mohan08]

Hi Manish,

Please find if the attached file is what you are looking for.

 

[msharma864512]

Hi Manish,

Please find if the attached file is what you are looking for.

Thanks for your help, but this is not what i am looking for

 

[bosco_yip]

1] Create 3 helper columns for Data validation list in Column K to Column M

2] [I4] Data validation list formula >> =$K$2:$K$6

3] [I5] Data validation list formula >> =OFFSET($M$1,MATCH($I$4,$L$2:$L$16,0),0,COUNTIF($L$2:$L$16,$I$4))

Regards
Bosco

 

[msharma864512]

View attachment 65015

1] Create 3 helper columns for Data validation list in Column K to Column M

2] [I4] Data validation list formula >> =$K$2:$K$6

3] [I5] Data validation list formula >> =OFFSET($M$1,MATCH($I$4,$L$2:$L$16,0),0,COUNTIF($L$2:$L$16,$I$4))

Regards
Bosco

Thank you Bosco for the help, I tried applying the same process and formula to my data, but its giving uneven data.

Attached is the spreadsheet.

 

[bosco_yip]

The 3 helper column in Column K to Column M are copied from the input table and Column L & M are sorted.

Please see the revised file

Regards

 

[p45cal]

Sort columns L & M by Sector (and if you want, secondarily by Company).

 

[msharma864512]

The 3 helper column in Column K to Column M are copied from the input table and Column L & M are sorted.

Please see the revised file

Regards

Ohh... Thats great, Thank you very much Bosco for all the help