How To Create Searchable Drop Down In Excel || Easy Steps || Hindi

How To Create Searchable Drop Down In Excel कमाल की Dropdown list एक्सेल में बनाये जो multiple cells में भी काम करेगी और multiple sheets में भी और Dynamically update automatic होती रहेगी 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 in multiple cells multiple sheets and dynamically auto updated.
#searchabledropdown
#excel
#deepakeduworld
#exceltutorial
Download Training File : drive.google.c...
Searchable list 1st video link : • How To Create Searcha...
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
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 -
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
Data Validation Part 13: • EXCEL में Data Entry क...
दोस्तों आपके Likes एंड Comments मेरे को Motivate करते हैं Batter और Useful वीडियोस बनाने के लिए। इसलिए प्लीज वीडियो को Like जरूर करे और वीडियो आपको कैसा लगा कमेंट में जरूर लिखो। अगर आपका कोई सुघाव है तो वो भी आप मुघे कमेंट में जरूर लिखो... Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_______________________________________
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
Tags: Internet,Computer user,Technology hindi, Learn Computer hindi,computer experts, excel user, deepak eduworld,computer tips,, excel tricks,tips,

[@DeepakEduWorld]

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

[@imthusan]

thanks deepak,bahooth badiya bhai

[@suryapakhrin9769]

After saved it ... the drop down list are not completely shown

[@farhadacca7314]

Dear Mr @Deepak , can you whatsapp me at 00971554876057 please

[@PharmacistRazique121]

Sab kaam thik se hogaya.aur save bhi kiye the file ko..lekin jab dobara file open kiye to sab khatam hogaya...

[@PharmacistRazique121]

@@suryapakhrin9769 same problem i faced

[@johnalfred93]

Hi Deepak Bro , I am a Medical Doctor but your excel videos were very very useful to me personally !!! Thank you brother!

[@DeepakEduWorld]

You r welcome doctor bhai 🤗

[@rahulgoenka4570]

Very well explained. I followed the video to the T and it really worked. Thanks

[@mithileshkumarsharma1807]

Abhi tak ka sabase sansar video thanks sir

[@ibraheemmshezad400]

BOHAT GREAT SIR ITS A AMAZING AND MAJICAL VIDEO SB KA SB CONCEPT CLEAR HO JATY HAIN AP KI VIDEO SA

[@jnbaluch]

Great sir..... very help full... you solved my problems ... God Bless you.....

[@suryamanikumar123]

Very Very Thank You So Much.... for prepare this type of knowledgeble videos....

[@rajeshshah6758]

Deepak Bhai, Aaj phir zaroorat padh gayi aapke is video ki. Kash mujhe aap ke jitna gyan hota toh ek bar mein aap ka video dekh ke aur bina dekhe main apni searchable drop down list bana paata. Thanks once again for the video.👍👍👍👍👍👍👍👍👍👍👍👍

[@DeepakEduWorld]

🥰🥰🥰

[@Test_yourknowledge]

Very useful video 👌👌👍

[@msaralihubli7648]

sir, it is very use full me thanks sir.

[@doojramyadav1450]

हेलो सर आपके समझाने का तरीका इतना प्यारा और सरल है कि कोई भी इंसान को तुरंत समझ मे आ जाता है आपने जो आज Searchable Drop Down फोर्मुला के बारे मे बताये है वह मेरे लिये बहुत ही काम का है इसके लिये मै आपको बहुत बहुत धन्यावाद देना चाहुंगा !

[@nurmohammed6355]

thanks, dear this trick., a very complicated, huge formula in one video.

[@kevalshirode7797]

Thank you It is helping alot

[@RahulKumar-ly6ly]

Thanks sir very helpful video happy holi sir

[@nidhitasaini5895]

U r the best teacher on u tube

[@ravidattkumar6153]

जय हिन्द ये वीडियो मेरे लिए बहुत महत्वपूर्ण है क्योंकि मुझे रोज 200 supplier में से 20-50 नामों की लिस्ट बनानी पड़ती है. इसकी सहायता से मेरा काम बहुत आसान हो जायेगा आपका बहुत बहुत धन्य बाद 🙏

[@bipinkumaryadav5411]

आपके सभी वीडियो लाजवाब होते हैं, बहुत अच्छी तरह से समझाते हैं। बहुत बहुत धन्यवाद 🙏🙏🙏

[@riazahmedmalik]

God bless you Deepak sir, thanks a lot for prompt response on request. You are a wonderful teacher.

[@srikanthgali8991]

U are my hero.

[@manojindrasan95]

Really this video is very very helpful. Thanks a lot

[@kvrwebservices9330]

Sir, very very useful video for me. Thanks a lot.

[@NewVoice5]

Ap to guru ho sir❤️

[@amansuthar1923]

Superb Thank you sooo much bohot kam kam ho gya iski wahaj se

[@sherwaliafridi1890]

You Are Toooooo Good Yaar

[@jitendrabomble2218]

Thanks. Nice information. 👌👌👍👍🌹🌹

[@gladsonjeremias4598]

Bohut badhiya dost. Mera dheer saara pyaar.

[@user-fb1ru1dj2r]

Very helpfulness.thank you so much Deepak ji.

[@animalworld2939]

Obviously very nice following your tutorials for more than two years . Thank you for your help and amazing tutorials.

[@adityavarma461]

Thanks guru ji

[@rehan2520]

Awesome... ma such ma is ko kal sy soch raha tha k searchable drop down list kesy bnaye

[@rajeshshah6758]

Hello Sir, Aaj Phir zaroorat pad gayi. Ek he baar mein samaj mein aa jata hai. Tussi Great Ho!!

[@pramodchandelpkc]

Very Helpful tricks

[@DeepakEduWorld]

😊

[@VinayKumar-vs8jd]

Very nice trick, it's very useful for preparing any MIS

[@sumitkumarbhandari6729]

Sir app genius ho...🙏🙏 What is Advance Excel? Advance Excel ke liye kon konsi topic jan na chahiye?

[@kvrwebservices9330]

Thank you very much sir. Very very useful video to me.

[@splendid1963]

👍great video. Your explanation is very nice

[@singhkulpreet95]

Really helpful video. Thank you sir

[@raj95122]

Sir aapko bahut bahut dhanyawad Is topic pr vedio banane ka Lekin sir isme ek or chij add krni hai Searchable ke sath multiple cell me multiple dependent list kese banaye please is topic pr bhi vedio banaye👌👌 Sir offset ka use krke jo name define kiya to use drop down list me indirect function ke sath kese use kare Please 🙏🙏

[@sukher_chabikathi]

Very useful video.. Thanks a lot.. U r awesome

[@DeepakEduWorld]

👍😊

[@dnanokar27]

वा मस्त। सही व्हिडीओ भाई। बहुत काम का व्हिडीओ।

[@DeepakEduWorld]

😊😊😊

[@mukeshsharma3948]

Thank you so much sir

[@md.shafiqulislam8121]

Thanks Dada, your video is very clear to understand. Many people is learning from those as needed

[@nikhilkukde6704]

Excel master ❤️❤️❤️❤️❤️

[@tarunuc]

You are genius bro. Great learning

[@santoshkumarpant219]

it is very helpful. thank you so much.

[@laxmikanth3395]

this is 200% work on Multiple inventory find for me thanks

[@DeepakEduWorld]

🤗😊

[@KaileshHambireIJ-G-]

Excellent video, i will try to make drop down for different GST RATES for tax invoice. I really wanted to learn this feature in excell, Thanks once again.

[@SanjaySolanki-lx4sy]

Sir mera naam sanjay solanki hai mene apke videos dekhkar excel me bahut kuch sikha hai...

[@vishalbhati912]

Bahot khatarnaak complication

[@ChintanSuthar02]

Really Helpful Brother.. Hats Off to your knowledge and easy explanation.

[@digzworld7805]

Salute hai bhai apko..

[@srikantamandal4858]

Very Helpful Video........

[@umairzahid3743]

beautiful sir zabardast.

[@karankumar-sx2mw]

Ase video pe 1 like to banta hai👌

[@empoweringnet2415]

I was looking for it for a long time, now i got it and it's quite good and use full for me, thanks

[@kabirsahib1552]

It's very lengthy formulas and process. There is an easy way to do it. Just single cell formulas.

[@islamkhan4142]

Verry thanks full off you bro

[@rhmanagoli]

Very useful

[@jigar7755]

Bahut sahi hai. Aapki list me kuch log real in item hai.

[@DeepakEduWorld]

😊

[@myhelpdesk6414]

Sir you are great, awesome.. Nice video thanks sir...

[@maheshagnihotri1333]

Deepak sirji, best in the world

[@Cricket_lover-g1i]

Really OWSM ❣️ Video But Hard-work hai thoda Dhyan dena padega 🙆🏻‍♂️

[@GopiNath-fp5ly]

Super video with lots of hard work.

[@soultouchsinging]

Very very very good video...👌👌👌

[@salaidhiraviyam8561]

Very useful. Thanks

[@muhammadfahad4552]

Excellent bro. Exactly what i need, I going to use it in Driver Manifest excel to fill the form. Thanks bro

[@sanjibkumar2627]

This is really helpful for me... I was searching for this for long time & watched so many videos... & finally my finding is over.... Explained very well... Thank you so much

[@javed4sm]

you are great

[@rajeshshah6758]

Superb Deepak Bhai.

[@MANOHARLAL-BHADU]

Very good

[@Technical3Idiots]

Wow...... Really this means!!! 🔥 🔥 🔥 🔥

[@abdulhamidalhaddadi2255]

Great Deepak

[@syedansarab3941]

THANK VERY MUCH FOR YOUR MOST VALUABLE INFORMATION

[@prashant1513]

Thanks Deepak Sir

[@shubhampatil4035]

Search drop down list multiple workbooks me operate hogi kya Means formula different workbook me. Aur use different workbook me

[@nilaykalol]

Very Very Useful

[@stardipto]

thnks fr sharing,but the whole process is tough enough

[@071538]

Great

[@abhishakya5263]

Good video

[@tarungargtkg]

Thanku for sharing valuable this ngs

[@spaceajay]

Awesome that's what I was looking for thanks a ton

[@mddelowarhossain1371]

You are an excellent teacher

[@vinodpareek8023]

Hi Deepak very nicely explained , I was looking such function for my purpose and got it after a big search, very useful will try to creat data enry for our use Thanks a lot Jai Hind

[@shivamdwivedi2492]

Dear sirI first watch and like and share this video

[@naushad123]

it worked

[@shyamsundarinfotech6449]

FABULOUS VIDEOS, I USE THIS WITH GST INVOICE BILL. ITS WORK GREAT. PLEASE MAKE A VIDEO FOR PURCHASE BILL ENTRY WITH ITEM AND LEDGER MAINTAIN.

[@DeepakEduWorld]

🤗 asap 👍

[@moynulmiah7291]

Thanks boss I am from Bangladesh

[@MANOHARLAL-BHADU]

बहुत अच्छा

[@mohammedshameelv74]

Thank you very much for this valuable knowledge

[@naeemqureshi4930]

mr deepak I m lover of your work and especially in excel skills.plz help me, I m facing some issues regzrding dropdown list. 1. when I trying to. copy paste,system returned as "#SPILL! even nothing in copy/drag in following lines.dropdown list copied properly but formula area showing spill error. 2.actually I want to apply in excel database. but facing above mentioned problem. regards your well wisher

[@arunkodkani9366]

this is very good vedio, please advise how to restrict any other value in that column other than the list.

[@krishanchauhan6679]

Thank you so much

[@laxmikanth3395]

very helpful for inventory control

[@khanaziz66]

U R great. Thanks dear.

[@DeepakEduWorld]

😊

[@krishnendubikashmajumder8898]

Seriously Boss thank you so much.

[@khanaziz66]

Really.

[@sherazrathoor8552]

Outclass video bhai eid mubarak

[@9928960170]

Very nice sir ji

[@JaspreetSingh-jp5qc]

Great job bro, i really appreciate your work👍👍👍👍

[@shubhampatil4035]

Its too useful video Ye searchable drop down list billing ke liye use kar sakte he kya Means items rate bhi aana chahiye

[@188ahmed188]

Well done 👏

[@salmanali920]

Sir thank you really very helpful everything is 100% clear. you are so nice teacher . teacher can we copy paste in another excel sheet can it work on other excel sheet i have try once but not working please guide me THank you salman Pakistan