Forum Discussion
raj jivani
Oct 16, 2018Copper Contributor
Searchable and dependable dropdown list
I Want to create a drop down list in multiple searchable drop down list which is dependent on earlier list
| District | Tehsil | Village |
| AHMADABAD | ASARVA | ASARVA |
| AHMADABAD | ASARVA | DARIYAPUR-KAZIPUR |
| AHMADABAD | ASARVA | HANSOL |
| AHMADABAD | ASARVA | HANSPURA |
| AHMADABAD | ASARVA | KOTARPUR |
| AHMADABAD | ASARVA | MUTHIYA |
I have a data similar to above table for all district of India
now i want to create similar list for data entry but it could be searchable
for Example If I type in a District column "AH" then drop down list only show suggestion of those district which contains "AH"
suppose I select AHMEDABAD from that drop down list and then goes to next column where I have to enter name of Tehsil
now if I type "DE" in that cell then drop down list only shows suggestion of those tehsil which contains "DE" and are comes under District "AHMEDABAD"
I hope, My problem is understandable
Thanks & Regards
Raj Jivani
raj.jivani93@gmail.com
1 Reply
- Lorenzo KimBronze Contributorvisit these sites:
https://www.contextures.com/xlDataVal02.html
https://www.excel-easy.com/examples/dependent-drop-down-lists.html