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]

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

[@DeepakEduWorld]

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

[@lestsmile]

You are Genius sir🎉🎉

[@sg-gaming6206]

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

[@KhurrumIqbal1]

Apka bataney ka andaz superb hai!

[@akhileshkumar-xp3eh]

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

[@kevinseeam4849]

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

[@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

[@ashiqmir2717]

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

[@manasbhattacharjee]

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

[@harkaransingh1190]

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

[@EasyDTH]

Very intelligent bro..

[@sarbchd9898]

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

[@kishupatel2839]

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

[@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 🙏🙏

[@shakilahmad7244]

Excellent h sir Aur bahut hi usefull bhi h

[@rajendrabendre6635]

Superb video sir ✨✔️

[@worldexpress9186]

sir aap bohat acha kaam kertay ho thanks

[@johnsonkv7734]

REALLY GOOD AND IT IS ;HELPFUL

[@akashkelkar1128]

aap to excel ke guru ho sir thank you

[@luhif110]

Very Good Explanation Keep up good work

[@uday1607]

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

[@pythusiast4701]

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

[@nitishkumarmishra4903]

kya kamal ki samjhate hain aap sir

[@aryan123raj]

very Nice....Excellent Deepak

[@mwxfl45h33]

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

[@kanhucharanadas3948]

Jabardast Dipak sir

[@DeepakEduWorld]

😊😊😊

[@vinaygaur8605]

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

[@dhananjaykumar-oj6xe]

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

[@yuva3444]

Really very useful & explanation.

[@suhb6387]

Sir, Deepak your master of excel

[@imranomar207]

A very knowledgeable video for excel lover . keep it up

[@mithukhalifa7460]

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

[@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

[@javed4sm]

very good friend and thanks for your efforts to learn us

[@twinklejaiyswal5172]

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

[@lahotanu]

SIR BAHUT HI BADIYA

[@gyanforyou7796]

Thanks sir itta acha batane ke liye

[@jaslokjha1410]

Thanks Deepak bhai❤

[@apshukla9]

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

[@dearloop1513]

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

[@santoshsawant4204]

Great work. 🙏🏻🙏🏻🙏🏻

[@rajuchrist7668]

Sir bht.hi badiya

[@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.

[@BakhtiarAUqaili]

Very good formula and excellent way to teach us

[@nahednaddu2971]

Very Nice Explanation Concept fully understand

[@fahimkhan357]

Very nice explain thank you so much

[@TheLibraannu]

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

[@harshadvegda8097]

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

[@sachincharde2883]

Ur great sir thank u so much

[@rastogi2006love]

Bahut badhiya :)

[@TVSCDN]

Thanks a million 🙏❤️👍🎉😍

[@archanamuppidi14]

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

[@syedelyas7090]

Hai Deepak.. Precisely explained ty so much

[@DeepakEduWorld]

☺️

[@shashikantha1803]

Superb, thanks for sharing and guiding

[@ranganathprahlad]

You are a good teacher. Thank you very much.

[@aggarwal4943]

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

[@sanjayadas7414]

So Inteligent u r ! Bro

[@andydufresne4513]

Aap master ho Sir

[@munmunkumar2117]

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

[@samirawati1975]

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

[@dkthetechiboy6505]

Best sir i love it.

[@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.........

[@DILIPKISAN]

The way u describe, I never get bored

[@prabhakarpawar573]

Nice and very usefull video sirji

[@jahangirsachwani8553]

Beautifully explained 👍

[@DeepakEduWorld]

😊

[@naveedahmedvt3613]

THANKS...EASILY UNDERSTOOD

[@rubelsk9378]

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

[@HumanistLogic]

Thanks bhai... you are awesome

[@awladhossain210]

Thank you so much. it helped me so much

[@banwarifageriaexcelclasses1447]

ITS WONDERFUL ..THANKS

[@DeepakEduWorld]

😊😊

[@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

[@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

[@kiranbandekar2434]

खूप छान सर

[@DigiRuns]

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

[@ismailjanab9653]

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

[@FarahVision]

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

[@amiran280]

Your explanations are so good. Thank you sir. Please help me : How we can use this formula multiple cells of another sheet.

[@trishnamoniroy5523]

Thank u sir from Assam

[@mrmrimran1]

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

[@DeepakEduWorld]

+mrmrimran1 ok

[@SunilSingh-ee4sc]

Impressed .... Mind-blowing idea thanks

[@sandeepgusain2154]

bhut badiya tha.

[@rajendrajomajipatil8314]

Thanks a lot Sir for this video

[@jjevishal]

Dear sir, Very useful video I applied in my excel sheet. I am writing order of my client in excel sheet. I am.making new sheet everyday according to date. Items are repeated everyday. So I want this formula in each sheet by keeping search matter only in one sheet of items How to do please reply. According to above vedio I think I need to copy paste item list in each new sheet. Please clear confusion

[@mdfazar2091]

Fantastic sir... Thanks a lot

[@DIOGOD28]

Hi Deepak thanks bro for this beautiful video is amazing and you are an amazing teacher. What you showed have worked perfectly but I wanted to apply this feature for multiple cells. But somehow when I copy or apply it to the other cells it takes the input of the first selection. Is there a workaround for this? Also can this me be applied to a combo box or a list box. If you any videos on this please let me know. Thanks in advance

[@ashunpj]

Thanks for sharing your knowledge.

[@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

[@bibekanandamanna5442]

Very nice....... Thanks

[@SalomeMasih]

Well explained, tysm

[@dillooshariff2452]

Great video and clear explanation. Thank you very 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

[@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

[@dnyandeosomawanshi9271]

Thanks for knowledge sharing and that too with such simplicity. Great & really worth sharing to others.

[@bhushanara]

Complex hai sir , but bahut achha h

[@poonamdhiman5140]

1st viewer. Tnx 4 video

[@srsandeepsinghnegi]

very nice video.

[@riazahmedmalik]

You are doing great Job bro. I follow your videos and learned a lot. Pls explain how to expand it on 30 to 60 cells.

[@DeepakEduWorld]

Next video is coming

[@riazahmedmalik]

Love the way you explain complex processes.

[@85pawanpau]

Thanku Sir Nice Video

[@vikasgodiyal8919]

Valuable video... Thanks 👍 Can we use all this formula in data validation source???