How To Create Searchable Drop Down List In Excel || Hindi || HD

#excel #excelmagictrick #searchabledropdown for Multiple cells is here • How To Create Searchab... Learn how to search data validation drop-down lists in Excel Hindi. In this Excel tutorial you will learn fantastic trick to make a searchable dropdown list with #autosuggest feature in Excel 2007 2010 2013 2016.
To create this searchable list in multiple cells and sheets see this video • How To Create Searchab...
Formulas used to create this dropdown list are:
1 search Formula
2 Isnumber Formula
3 If Formula
4 max Formula
5 rows Formula
6 vlookup Formula
7 iferror Formula
8 offset Formula
9 Countif Formula
Download Training file:
drive.google.c...
vlookup in excel with example in Hindi
• Vlookup in Excel With ...
How to use IFERROR formula in excel || HINDI
• How to use IFERROR for...
Countif formula in excel
• COUNTIF formula in exc...
If formula in excel
• IF Logical Function in...
This a an amazing trick so go ahead and create a searchable dropdownlist in excel
Data Validation Part 1: • Data Validation in Exc...
Data Validation to allow only whole numbers between an upper and lower limit
Data Validation to allow only decimal numbers below or equal to an upper limit
Create an Input Message for your Data Validation
Error alert Message with "Stop"
Error alert Message with "Warning"
Error alert Message with "Information"
Data Validation Part 2: • How to Create Drop Dow...
Data Validation drop down list using a range of cells
Data Validation drop down list using a Defined Name
Make data validation list from another worksheet in excel 2007
Data Validation Part 3: • Data Validation In Exc...
Data Validation to allow only dates between an upper and lower limit
Data Validation to allow only times above or equal to a lower limit
Data Validation to allow a certain text length
Data Validation Part 4 : • Custom Data Validation...
Allow only numbers in cell & Set limit of digits to accept.
Allow only text in cell & set character limit to accept.
Allow only 10 digit mobile number in cell
Data Validation Part 5 : • Excel में Duplicate En...
Prevent Duplicate Entries In Column
Allow Only Unique Entries - Avoid duplicate entries in excel using
Data Validation Part 6: • Data Validation Auto U...
Auto Updating Dropdown List In Excel Hindi
Data Validation Part 7: • How To Create Dependen...
How To Create Data Validation Dependent Drop Down List In Excel
Data Validation Part 8: • EXCEL - ये विडियो 😮 जर...
EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number
Data Validation Part 9:https: • Custom Data Validation...
Custom Data Validation- To Allow only Uppercase Text Entries In Excel
Data Validation Part 10:https: • How To Create Searcha...
How To Create Searchable Drop Down List In Excel || Hindi || HD
Data Validation Part 11:https: • How to Create Drop Dow...
how to create drop down list from another sheet in excel
Data Validation Part 12: • Data Validation Auto U...
Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List
Data Validation Part 13: • EXCEL में Data Entry क...
EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
ADVANCED MS EXCEL के लिए ये playlists देखे: goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: goo.gl/bbHYu2
MS WORD के लिए ये playlist देखे: goo.gl/B4TeSA
HTML5 & CSS3 के लिए ये playlist देखे: goo.gl/2PFgs8
COMPUTER के TECHNICAL videos के लिए ये playlist देखे: goo.gl/paZmpn
Subscribe to my channel: / deepakeduworld
Like my Facebook page: / deepakeduworld
Follow on LinkedIn: / deepakeduworld
***********************************************************
Thanks for Watching
Happy Learning
DEEPAK NEHRA
***********************************************************
Tags:
कंप्यूटर, दीपक ऐडवर्ल्ड, एक्सेल,Internet,Computer user,,Learn Computer hindi, ms office,ms excel,word, excel course, hindi technology, deepak eduworld,computer tips, shortcut keys, excel tricks,tips,

[@DeepakEduWorld]

*To make this searchable dropdown in multiple cells or multiple sheets watch this 2nd video* kzbin.info/www/bejne/mJjQdpp8rtSIiaM

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@akhileshkumar-xp3eh]

Very Interesting Sir I have watched full video without skip Thankyou So much Sir..........

[@rajkumargupta2856]

Super explanation sir 👌👌 I had many problems in enable searchable drop-down in Excel but after watching this video I have any problem now. 🙏🙏Very very thanks sir 🙏🙏

[@sg-gaming6206]

Bth achy say guide kia ap nay ik hi bar mai sab achy say pata lag jata hai

[@poonamdhiman5140]

Sir aap ki excel knowlege incredible h. Aap language formulas excel me bahut ache se implement karte h.

[@DeepakEduWorld]

Poonam Dhiman thanks

[@SHADABKHAN-lq6zj]

Sir aapki video bht achi होती है Sir मुझे ये janna tha mera jewellery box का काम he तो अलग अलग साइज़ होते ही और design भी टैक्स सबका ak होता ह to मे उनके design के saath rt भी और cod भी aa जाए gst bill me

[@kevinseeam4849]

from all the videos i've watched thats the only one that worked like a charm

[@manasbhattacharjee]

Nice & easy way to elaborate step by step formula. Thank You

[@mewaramtoliya53]

Sir yous all the excel vedio is most usfull for me so i can not dislike its, I like the excel from deepak eduword education, mari comment se aapko khed lga, I am sorriy

[@KhurrumIqbal1]

Apka bataney ka andaz superb hai!

[@uday1607]

Superb sir, Simply fantastic. All the best. Your videos are MUST for every learner.

[@kanhucharanadas3948]

Jabardast Dipak sir

[@DeepakEduWorld]

😊😊😊

[@rajuchrist7668]

Sir bht.hi badiya

[@harkaransingh1190]

Sir i am from punjab i learned a lot of things from you

[@twinklejaiyswal5172]

Good and very simple tricks so very nice and good exaplane Thank you so mach Tack care Deepak sir

[@nitishkumarmishra4903]

kya kamal ki samjhate hain aap sir

[@worldexpress9186]

sir aap bohat acha kaam kertay ho thanks

[@rajendrabendre6635]

Superb video sir ✨✔️

[@dhananjaykumar-oj6xe]

this must be necessary question for school practical... awesome sir awesome... really

[@EasyDTH]

Very intelligent bro..

[@mithukhalifa7460]

Your video very smart and clear . Thanks for making this video

[@suhb6387]

Sir, Deepak your master of excel

[@mwxfl45h33]

Great work sir.. we need this trick even after 5years..

[@imranomar207]

A very knowledgeable video for excel lover . keep it up

[@sarbchd9898]

sir kya baat h m tu apka fan ho gya Great job

[@kishupatel2839]

Excellent sirji.. it is too much useful for me.

[@ashiqmir2717]

No words to describe it.... Simply Awesome....

[@mrmrimran1]

very good channel, plz also make video for making database of daily use excel file.

[@DeepakEduWorld]

+mrmrimran1 ok

[@TVSCDN]

Thanks a million 🙏❤️👍🎉😍

[@Uttambakale9]

You are Genius sir🎉🎉

[@akashkelkar1128]

aap to excel ke guru ho sir thank you

[@sandeepgusain2154]

bhut badiya tha.

[@pythusiast4701]

Awesome deepak... this video is very helpful.. you are really a teacher. Hats off

[@luhif110]

Very Good Explanation Keep up good work

[@dearloop1513]

I was looking for this video and found this amazing. It is like a champion.

[@BakhtiarAUqaili]

Very good formula and excellent way to teach us

[@gyanforyou7796]

Thanks sir itta acha batane ke liye

[@jaslokjha1410]

Thanks Deepak bhai❤

[@munmunkumar2117]

Your Video is very helpful us. thank for make this type video sir

[@yuva3444]

Really very useful & explanation.

[@AJEETDIGITALSERVICE]

Dear Sir you are very expert in MS Excel Sir mai chahta hu ki type karte hi drop dwon ki list autometic khul jay jaise google me show hota ha

[@rastogi2006love]

Bahut badhiya :)

[@ajayint001]

Thank you so much sir....... Please ise our asan kaise kar sakte hai..isme formulas bahut use huwa h

[@DeepakEduWorld]

+Ajay Kumar ok g.. I will publish video as soon as possible

[@samirawati1975]

sir ji aapp gr8 ho.... thank you very very very very much...... pranam aapko

[@Naturalist0]

Thanks Deepak ji, searcheable drop down list banana toh aapne sikha diya - lekin yeh toh ek single cell mein locked hai. Please bataiye isko drag down / dusri cell mein copy kaise karen.

[@DeepakEduWorld]

Ys.. I will publish video shortly

[@andydufresne4513]

Aap master ho Sir

[@rubelsk9378]

Sir, thanks thanks thanks.. ......

[@shakilahmad7244]

Excellent h sir Aur bahut hi usefull bhi h

[@lahotanu]

SIR BAHUT HI BADIYA

[@fahimkhan357]

Very nice explain thank you so much

[@santoshsawant4204]

Great work. 🙏🏻🙏🏻🙏🏻

[@vinaygaur8605]

I know it is lengthy but very innovative ..... thanks for such beautiful information

[@shashikantha1803]

Superb, thanks for sharing and guiding

[@apshukla9]

Awesome.. salute for your hard work keep it up 👍

[@prakashmayyak9916]

Super explanation. I have watched some other videos in which they give some formula to acheive some desired output. But, you explained each and every step for selecting a formula. All the very best. Thank you once again.

[@harshadvegda8097]

Deepak Sir, Excellent Formula Developed. This may not be in the minds of MS Office !!!

[@dkthetechiboy6505]

Best sir i love it.

[@shakhyamukherjee871]

Deepak sir khub valo laglo ei video ta....bolchi sir Searchable drop down list hoye jaber por jodi onno item add korte chai seta aber drop down list e show korbe tar jonno ki kora dorkar

[@FarahVision]

Too good deepak. but Thora sa easy kr k samjha den ye method plzz.. ye to boht tough hai...

[@DigiRuns]

Oh my god, sir, u r a great Faculty in teaching and researching. Thanks for this wonderful tutorial.

[@sazalsarkar2130]

Wow Dada.

[@goutamkarmoker4602]

Nice teacher

[@archanamuppidi14]

Wow... ur doing sooo much of help... thank u for sharing.... very good explanation and presentation... great job...

[@prabhakarpawar573]

Nice and very usefull video sirji

[@aryan123raj]

very Nice....Excellent Deepak

[@bhushanara]

Complex hai sir , but bahut achha h

[@TheLibraannu]

Thank you so much sir, me bahut tym se ye seekhna chah raha tha, u r amazing...

[@naveedahmedvt3613]

THANKS...EASILY UNDERSTOOD

[@kiranbandekar2434]

खूप छान सर

[@farooqm2820]

Thanks alot. What if I have to make multiple dropdwns??

[@sachincharde2883]

Ur great sir thank u so much

[@shashankyadav5549]

Thank Your Sir Qki m 2 mnths se searchable drop down dekh rha tha different different youtube video k threw but finally aapki is video m step by step saare concept clear h is video k baad. Sir 1k q. h agr hme number format m Searchable drop down chaiye to uske liye kya SYMBOL hoga jaise Text ("?*") then Number = ?. please help me.... Thank You

[@mr.a_a9407]

Awesome .. thank you

[@ConsulthinkProgrammer]

Try this to bring search in google sheets to the next level with keywords name and birth date kzbin.info/www/bejne/joDdg3atrqiemqM

[@syedelyas7090]

Hai Deepak.. Precisely explained ty so much

[@DeepakEduWorld]

☺️

[@sanjayadas7414]

So Inteligent u r ! Bro

[@nahednaddu2971]

Very Nice Explanation Concept fully understand

[@javed4sm]

very good friend and thanks for your efforts to learn us

[@johnsonkv7734]

REALLY GOOD AND IT IS ;HELPFUL

[@HumanistLogic]

Thanks bhai... you are awesome

[@srsandeepsinghnegi]

very nice video.

[@trishnamoniroy5523]

Thank u sir from Assam

[@YOGESHTEACHER]

सर dependent searchable drop down list पर एक वीडियो बनाइए plz

[@DeepakEduWorld]

Sure 👍👍

[@rajendrajomajipatil8314]

Thanks a lot Sir for this video

[@indianmonster1445]

Best For ever...................... One Query : - how to highlight particuler cell via drop downlist " Condition :- 50 Document names in my list , highlight list via Country name & Party name , using Dropdown list.........

[@ismailjanab9653]

Thank you for this video. it will help me a lot. easily explained

[@homegamingfmr1348]

Hi sir good morning this is very helpful video I need one favor I have 30 sheet data so how’s set all sheet thanks you sir

[@DeepakEduWorld]

Same data in all sheets?

[@riteshkumar9390]

its amazing. Par kya ise hm invoice billing page mai use kar sakte hai jisme hume multiple sheets and lines mai ye list chahiye hogi. agar haa to kaise

[@starblack9419]

Thank you so much

[@aggarwal4943]

This is Amazing ... liked it very much.. thank you for explaining it so simply

[@shivkumarmahoniya8246]

Nice and new idea

[@shankarab1127]

sir, had tried it , it working for single cell only , if same copied and pasted to subsequent rows it only provide the previous data only, please suggest

[@DeepakEduWorld]

Please see first comment below of this video to make it.. In Multiple cells

[@infocare2210]

THANK YOU SIR

[@aasif19]

Hello Sir, I find ur videos very useful and I am thankful to u for such wonder full video. Sir meri ek request hai, mujhe marriage party mein guest ke liye jo card per name stickers banate hai vo banvana hai... plz agar aap vo bana sakte hai easy way mein to uska ek video zaroor banvaiye

[@DeepakEduWorld]

+Asif Ahmed ok g..

[@banwarifageriaexcelclasses1447]

ITS WONDERFUL ..THANKS

[@DeepakEduWorld]

😊😊

[@bibekanandamanna5442]

Very nice....... Thanks

[@SewingTech]

Thanks bro

[@ranganathprahlad]

You are a good teacher. Thank you very much.

[@aslam939]

Great..

[@JJ-gi8nx]

zberdust bless you

[@vijaytaneja8667]

very very nice sir ji