Create Advance Dependent Drop Down List in Excel in HINDI [Step-by-Step Tutorial]

▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
▓▓▓▒▒▒░░░ Open This Description ░░░▒▒▒▓▓▓
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
Part 1:- 3 Method to Create a Drop Down List in Excel HINDI
www.youtube.co...
********Click Below LINK to Download Excel Sheet for Practice*********
drive.google.c...
**************************************************************************************
Create Dependent Drop Down Lists or How to Make Dependent Drop Down Lists How to make dependent dropdown lists in Excel
Limit the choices in an Excel drop-down list, depending on the value in another cell.
Here are the step-by-step instructions for making dependent drop-down lists.
A drop-down list is an awesome tool. You can pre-define some values and user can enter data by selecting one of those values.
One of its advanced features is a “Dependent Drop Down List”.
A dependent dropdown is all about showing values in a drop-down list according to the selection of the value in another drop down.
In this video, you have two drop-down lists. Size drop-down is dependent on product drop down.
If you select the white paper in product cell then in size drop down will show small and medium.
But, if you select gray paper then its size will be medium and large.
So here the basic idea to create a dependent drop down list is to get correct size as per product name.
So let’s get started.
Steps to Create a Dependent Drop Down List in Excel
For creating a dependent drop-down list we need to use named ranges and indirect function. And, please download this sample file from here to follow along.
First of all, you have to create named ranges for drop-down lists. For this, select product list. Go to - Formulas - Defined Names - Create from the selection.
You’ll get a pop-up. Tick mark “Top Row” & click OK.
By using the same steps, create two more named ranges for sizes. One is for white paper and second for the gray paper.
Quick Tip: By using this method to create a named range, the value in the first cell will be considered as the name and rest of the values as the range. You can also use a dynamic named range for this.
Now select the cell where you want to add product drop down and Go to - Data - Data Tools - Data Validation.
In data validation window, select “List” and in “Source” enter below formula and then click OK.
Select the cell where you want to add size drop-down list. Go to - Data - Data Tools - Data Validation.
In data validation window, select “List” and in “Source” enter below formula and click OK.
=Indirect(“A5”)
Finally, your dependent drop-down list is ready. You can download this sample file from here to try it yourself.
How does it work
First, you have created three named ranges. Then we have used one named range to create product drop down.
After that, for the second drop down list, you have used indirect function & refer to the value in product cell.
If you notice, our size named ranges has name equals to the values we have in product drop down.
When we select “WhitePaperSheet” in product cell, then in size cell indirect function refer to the named range “WhitePaperSheet” and when you select “GreyPaperSheet” it will refer to named range “GreyPaperSheet”.
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u

[@Gudakesha158]

aapne bahut tarike se samjhaya hai, i was searching for the same but after watching your now I understand

[@alokeshize]

Excellent, your presentation and explanation both are well and good and easily understandable.

[@robingosain3506]

Excellent video, it deserves more likes

[@entiredworld255]

very important videos...... jaisa ki aapne bataya ki ye videos kuch aalag hatke hai.... is videos me kuch excel series ka knowledge advance me learn karne ko mila hai.....

[@ComTutor]

thanks.

[@manendrakumarmandle6968]

Helpful and clearly define depends drapdwoun list other video compear***** Five star ⭐⭐⭐⭐⭐

[@ComTutor]

Glad you think so!

[@gangadharbhardwaj]

very nice

[@MushtaqQureshi]

Need to learn more from you. kindly train us to add/expand at least 4/5 dependable list for better learning .

[@kavitacharya659]

Kya hum ye formula Google sheets pe bhi use kr sakte hain?

[@samimsedeqey8231]

Hi sir, after applying the indirect and substitute formula (=indirect(substitute($b3," "," _")) a massage pops up like ( the source currently evaluates to an error.do you want to continue?) When pressing yes it doesn't work? How to fix .

[@aamirshahzad2659]

[@sharjeelsheerazi]

Good presentation

[@omkarkelshikar7484]

Sir very nice video but sir data validation ka or advance video banvo tako very useful ho ,👍

[@ComTutor]

okay abhi iski puri series ready karni hai to wo bhi bna dunga.

[@paviliongamer4688]

Very usefull

[@safeerahmed8252]

I have a simple list in cell A2 its values are “Yes” and “No”. I want this cell A2 as mandatory; mean it should never be empty. But a problem is there, when I press delete from keyboard, it deletes list element from said cell and no error is displayed. How can I do it with data validation WITHOUT USING VBA?

[@Gudakesha158]

Thanks a lot sir

[@joicefargen.g6692]

Sir, please give a video about match formula for MULTIPLE DROPDOWN LISTS & get a result by that MULTIPLE DROPDOWN LISTS. And the dropdown lists and result are show in ANOTHER SHEET in the excel.

[@SudhirKumar-bx3rk]

Govind ji, I have seen your vedio on dependant drop down list in excel. I want to know whether is it possible make reversible depends list. As sometimes we know the product name but do not know in which category it falls. Please reply or post a vedio if it is possible.

[@keshavrammahawar0807]

Year ki advance dependance list kase banate h

[@MushtaqQureshi]

Very well explained just tell us or make the list auto expandable and auto sort A to Z and or small to large. The practice sheet is not expandable.

[@ComTutor]

okay will work on your concern.

[@learnwithlokeshlalwani]

The video was very informative. I have posted a similar content video on my channel.

[@arijeetkumarsharma226]

Awesome

[@kirandeepchoudhry9232]

Awesome Sir

[@ComTutor]

thanks.

[@maakamakhyacomputer2934]

MST video hai sir ji

[@ComTutor]

thank you. please comment karte rahiye. motivation milti hai.

[@prabhakarpawar573]

Nice video sir

[@ComTutor]

thank you

[@agarwalsaransh4244]

Sir can I make a drop down list like if I type A then only the option starting with "A" in list will be shown to me, as I am having huge data and difficult to search one by one from drop down list. Sir please reply.

[@RohitKumar-uy7cx]

Sir automatically update sheet kaise tyar krte hai jisme data feed kre aur vo save kisi dusri sheet pr jaa k save ho jate remove ho kr

[@rabbanisayyad1887]

👌👌👌

[@pratapitsolutioncybercafe7898]

sir mai chahta hu ki 1st colum ka data down list se select karu to usi ke anusar usse related uske data change ho jye right row me. like mai marks sheet banana chahta hu aur result dekhne ke kiye list create karna chahta hu aur jis candidate ka naam select karu uska sare sub na no percent ye sab aa jye . so kundly suggest me.

[@ComTutor]

Just send me your query sheet with your respected data so that i can answer you accordingly.

[@satscoolstyle4210]

Bhai data validations mai ek problem ati h agr koi normal cell ko copy krk data validations cell pr paste krta h to data validations ht jati h or wo cell ek normal cell bn jata h to iska koi solution pr video bna do it will help to all excel users

[@ComTutor]

kyoki jha aapne data validation apply kiya hai wo blank cell hota hai, aur jab usme koi data paste karte hai to wha pr sab kuch paste ho jata hai matlb copy kiye huye cell ka format bhi, value bhi font bhi, isse bachne ke liye aap paste special mei jakar only value ko data validation wale cell mei paste kro, ho jayega. and thanks for comment.

[@sukhenkumar8194]

Esme ydi mujhe total show krwana h to kaise kre

[@KnowledgeofAhmad]

Sir Searchable Maltipal drop down kaise bnate h Or mene net pe dekh wesa bna liya but pahle wale m search kiya huaa hota h wahi dusre wale m dikhata h chahe dusra name search kar lo is ka koi solutions h kiya 1 solutions bataya tha formulas ke ander ( calculate now) wala Ye kaam nahi kiya 2 developer m wo bhi nahi kiya Please koi solutions batao

[@imranali-iy5wk]

Excel 2019 features?

[@ComTutor]

i'll work in all Excel version

[@user-tw9if4rt2x]

Excellent, your presentation and explanation both are well and good and easily understandable.

[@ComTutor]

thanks.