What a clear explanation brother. I have a question, I have a workbook with 3 sheets, ie an Invoice, Cliente database and Product database. I have created a searchable multi cell dropdown box list and a single dropdown list for cliente. If I use a indirect(cell("address")) function, the dropdown lists conflict. How mai I avoid this?
Quick question, PK. I was able to use your method for my own list; it works fine on the page with the array, but how would I be able to carry that formula for the searchable drop-downs down a column on another page?
Excellent explanation... but I have a question, can u tell me how to show "No Record Found" in the dropdown list when any keyword doesn't match with given data?
Thanks nice one question .I need to fix searchable drop down list for particular colum ex A:1 to A:50 .how can I see this forumala .you have demonstrated for one cell my case is conescutive colum.pls explain
Thank you so much for this video. What if I have multiple dropdown menus on a sheet? Once the index and frequency are set to 0, I can't use the next drop-down menu to search. Can you help me please?
Great Video!! Awesome Job. It seems to not work in Office 365. This is the second video that I have followed and it still didn't work. I watched the video 100 times and made everything exact... It does not search. It always shows the same complete list. Can I please get some help? Everything worked until I put it in the drop down. Thanks
I fixed it... The "list" I pasted in the data validation was of the complete list...Not the list with formula attached. I hope this makes sense. Thanks Again.
Sir, while searching anything,it will work only for 1st word. Example if i am searching auto clave indicator, it work only for A word if if type au it won't work pls help
If i copy the cell G4 and paste on G5 then result is not right, because in search I freeze G4. So If i make a range of drop down cells then what should I do.
Hi Faisal, If you want to use searchable dropdown for multiple cells then below given video link will help you th-cam.com/video/dDPwq4REZac/w-d-xo.html
Hi PK, I have problem while I'm searching the record .. the first record is missing and showing rest all records. for example if I search ind it is showing only Indonesia but not showing India
Thanks a lot, But i have one problem, How i open drop down list after i will type some words with keyboard, i was try to open with alt + down arrow but it doesn't work, please give suggestion... Thanks
Very usefull! But now... I have a list of tasks in row 1 to x.Somewhere I have a list of 10 employees.Behind each task I want the name of 3 employees.And so on for the other tasks. Like this. Tasks Emp#1 Emp#2 Emp#3 Task #1 John Pete Harry Task #2 Harry Bill Task #3 Charles Kate John Task #4 Pete Kate Task # They all use the same validation field, Emp_list. Is there a way to solve this?
Thanks for your valuable feedback Willem. Do you want dependent drop of emp list for Tasks or anything else? I have understand your data but could not understand your requirements. Please elaborate it little bit more.
Thanks for your quick response! I want a dependent dropdown, just like you showed in your video, but for employees. I want to pick the employees from the list. The tasks are already in Column A. For now I don't need an empty list, but maybe in the future.
Hi PK, how we can create a lottery userform in excel with these labels like name ,father's name,address,ID card no, passport no, with add data commondbutton. And also how to save the records (data) in excel sheet in back ground.Thank you so much in advance. please email me
No problem sir continue with English i m also uploading video in hindi my channel name is RRP Excel Hero's... I m really thanks to you because i am learning from watching your videos... Thanks alot
Thank you so much for this useful and helpful method. It's very well explained.
You're very welcome!
very brilliant and helpful idea brother
Thanks for your valuable feedback
thank you very much its really helpful
Thanks for your valuable feedback
I could kiss you. This was so easy to learn and implement and it was exactly what I was looking for!!! Thank you so much!!
th-cam.com/video/EKKFLt5ItKc/w-d-xo.html
Very good idea useful and simple, Thank you man
Thanks for your valuable feedback
Fantastic! It works. Thanks so much!
Question: Why does this not work for the rows below?
Glad it helped!
You can watch below given video for multiple cells
th-cam.com/video/dDPwq4REZac/w-d-xo.html
This is a excellent work ... it realy worked for me... hat off sir
Thanks for your valuable feedback
What a clear explanation brother. I have a question, I have a workbook with 3 sheets, ie an Invoice, Cliente database and Product database. I have created a searchable multi cell dropdown box list and a single dropdown list for cliente. If I use a indirect(cell("address")) function, the dropdown lists conflict. How mai I avoid this?
th-cam.com/video/EKKFLt5ItKc/w-d-xo.html
amazing solution bhai.. just one question , should i save the helper rows or can i get rid of them ?? also can i move this search box to another tab ?
Very good, nice explanation, this has really helped a lot. Thank you!
Thanks for your valuable feedback
i realize Im quite randomly asking but do anyone know of a good website to watch new movies online?
@Dexter Gavin flixportal :D
@Knox Zavier Thank you, I signed up and it seems like a nice service :) I appreciate it!
Very useful, it's an amazing work.
Thanks for your valuable feedback
Quick question, PK. I was able to use your method for my own list; it works fine on the page with the array, but how would I be able to carry that formula for the searchable drop-downs down a column on another page?
Super helpful! Thanks so much :)
Thanks for your valuable feedback
Excellent explanation... but I have a question, can u tell me how to show "No Record Found" in the dropdown list when any keyword doesn't match with given data?
you best it's very easy with you
Thanks for your valuable feedback. Please share it with your friends and colleagues.
Hello pk! It would be much helpful if you can upload a video for dropdown calendar.
Thanks sir
Most welcome
U r my god 😍
Wow.. Thanks a lot
Thanks for sharing this great trick.
I wonder if you can use this dropdown list in a excel table.
Thanks for your valuable feedback. Below given article will help you:
www.pk-anexcelexpert.com/searchable-drop-down-list/
Thanks again. I saw that you made another video with the solution to my question. This will be of great help for me. I appreciate it. Best.
Thanks for your valuable feedback
Thank you! This has really helped a lot :)
Thanks for your valuable feedback
Excelente y muy bien explicando, saludos
Thanks nice one question .I need to fix searchable drop down list for particular colum ex A:1 to A:50 .how can I see this forumala .you have demonstrated for one cell my case is conescutive colum.pls explain
Thank you so much for this video. What if I have multiple dropdown menus on a sheet? Once the index and frequency are set to 0, I can't use the next drop-down menu to search. Can you help me please?
th-cam.com/video/EKKFLt5ItKc/w-d-xo.html
Very useful, thank you
Thanks for your valuable feedback
Excellent trick!👍
Thanks for your valuable feedback
Great Video!! Awesome Job. It seems to not work in Office 365. This is the second video that I have followed and it still didn't work. I watched the video 100 times and made everything exact... It does not search. It always shows the same complete list. Can I please get some help? Everything worked until I put it in the drop down. Thanks
I fixed it... The "list" I pasted in the data validation was of the complete list...Not the list with formula attached. I hope this makes sense. Thanks Again.
Excellent sir
Thanks for your valuable feedback
Amazing work, sir; just wonderfull!
Thanks for your valuable feedback
Sir, while searching anything,it will work only for 1st word. Example if i am searching auto clave indicator, it work only for A word if if type au it won't work pls help
If possible then decrease the length of your welcome tune otherwise everything is good.
Thanks for your valuable feedback.
Good Pk..awesome bhai
Brilliant!!! Thanks a lot for this tip! ;)
Thanks for your valuable feedback
ho do we get the formula wok for multiple cells in a column - it works only for one cell in a column
awesome .. thank you ..
Thanks for your valuable feedback
If i copy the cell G4 and paste on G5 then result is not right, because in search I freeze G4. So If i make a range of drop down cells then what should I do.
Hi Faisal,
If you want to use searchable dropdown for multiple cells then below given video link will help you
th-cam.com/video/dDPwq4REZac/w-d-xo.html
th-cam.com/video/EKKFLt5ItKc/w-d-xo.html
Hi PK, I have problem while I'm searching the record .. the first record is missing and showing rest all records. for example if I search ind it is showing only Indonesia but not showing India
What do i have to do if my list has repeated names?
Thanks a lot,
But i have one problem,
How i open drop down list after i will type some words with keyboard, i was try to open with alt + down arrow but it doesn't work, please give suggestion...
Thanks
Good..
Thanks for your valuable feedback
How to filter column data of "country name" and show it on header of the column by this searchable drop-down list
th-cam.com/video/EKKFLt5ItKc/w-d-xo.html
Nice
Thanks for your valuable feedback
Very usefull!
But now...
I have a list of tasks in row 1 to x.Somewhere I have a list of 10 employees.Behind each task I want the name of 3 employees.And so on for the other tasks.
Like this.
Tasks Emp#1 Emp#2 Emp#3
Task #1 John Pete Harry
Task #2 Harry Bill
Task #3 Charles Kate John
Task #4 Pete Kate
Task #
They all use the same validation field, Emp_list.
Is there a way to solve this?
Thanks for your valuable feedback Willem.
Do you want dependent drop of emp list for Tasks or anything else?
I have understand your data but could not understand your requirements.
Please elaborate it little bit more.
Thanks for your quick response!
I want a dependent dropdown, just like you showed in your video, but for employees.
I want to pick the employees from the list. The tasks are already in Column A.
For now I don't need an empty list, but maybe in the future.
Is an immediately select possible?
Now you first have to click on the dropdown button to pick a name from the list.
Hi PK,
Is there a way to upload a file?
Maybe I have an interesting solution!
how to prevent wrong data ? Data validaiton not work
Hi PK, how we can create a lottery userform in excel with these labels like
name ,father's name,address,ID card no, passport no, with add data commondbutton. And also how to save the records (data) in excel sheet in back ground.Thank you so much in advance.
please email me
Please upload hindi video also
Hi Radhe,
Thanks your valuable suggestion but 70% audience of my videos doesn't understand Hindi.
No problem sir continue with English i m also uploading video in hindi my channel name is RRP Excel Hero's...
I m really thanks to you because i am learning from watching your videos...
Thanks alot
Sir , y ek hi cell me search hoti h , har cell me searchable drop down list hone chahiye , y kese banegi iske bare btaye ? Plz
Please visit below given article:
www.pk-anexcelexpert.com/searchable-drop-down-list/
Sir this is working on just select rows, how we make in multiple rows ?? Please reply
I can't insert the list in the data validation, you said press m 3...
Hi Ricardo,
Thanks for your valuable comments. Please press F3 to paste the name range.
Achha hai topic or yr video todi saf bna lo formula dik he nhi rha
Query :- " how freeze cell on laptop ???"
F4 use - pc
Laptop - ???
F4 is used with laptop and PC both to freeze the cells.
Press Fn+F4 in laptop.
Use fn+f4
too many ads. thumbs down on this for all the interruptions