Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
481
Views
Topic starter
how can create searchable dependable dropdown list in excel
but both are searchable
example
| item | party |
| A | ramesh |
| B | chagan |
| C | ramkishor |
| D | chandara |
| A | magan |
| B | rahul |
| C | chandu |
| D | nandu |
| E | kalu |
Posted : 07/05/2021 6:21 am
Hi Bhavnesh,
Welcome to our forum!
Excel doesn't have searchable functionality unless you're using Excel Online. Here are some tutorials on how to build dependent drop down lists:
https://www.myonlinetraininghub.com/excel-data-validation-with-dependent-lists
https://www.myonlinetraininghub.com/excel-dependent-data-validation
I hope that helps.
Mynda
Posted : 07/05/2021 8:45 pm