Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
69
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