Dependent Drop Down list in excel | Dependent dropdown list using Indirect formula in excel (CC)

How To Create Dependent Drop Down List In Excel || Best Video in Hindi | Dependent Drop Down list in excel | Dependent dropdown list using Indirect formula in excel.
#dropdownlist #indirectformula #computergyanguruji
File download link - drive.google.c...
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic

[@TVSCDN]

Thanks Guruji for your invaluable Gyan in Excel Drop-down list 🙏❤️❤️❤️

[@mudassirhussain1935]

Very Easily and live method is awesome

[@hussainwarraich8139]

I'm watching your videos for last 7 days! You're one of the best teacher! Huge respect Manoj Ji 🙏🙌❤️

[@amiteducational4006]

Thanks... Aapka btane ka tarika best hai

[@avr9747]

Your basics are so clear. Kitna simplify karke explain karte ho. Hats off. Put more videos in excel advanced+machine learnimg+data analysis&management. Many thanks

[@ComputerGyanGuruji]

I will try my best

[@walimuhammad.ch2020]

Thank you

[@jitendrabomble2218]

Thanks sir. It's very useful information. 👏👏👏

[@ComputerGyanGuruji]

Keep watching

[@mrinalbera5661]

Thanks sir for explaining

[@NoorAli71184]

❤❤very nice Iive long life

[@jaswantsinghtomar3694]

Bahut badiya

[@parthopratimdas175]

Thank you sir

[@JaswantSinghBisht]

Great job sir

[@pronabdey5864]

Excellent Explained Sirji ,🙏

[@yogeerajswami8521]

Best

[@bijaytanty8434]

Thanks Sir 🙏

[@ashokprajapati142]

ખૂબ સરસ સાહેબ ....સલામ છે તમને

[@abhishektomar1982]

Guruji ms excel ka toturial for begginers bhi lekar aayiye Jaisa aap ms word ka lekr aye the Mujhe ms word bht ache se smjh aa gya pls excel bhi smjhaye starting se

[@saurabh17sharma68]

Shabash shabash

[@nadirazizaziz8172]

I like your information video. Send me more info. Thank you

[@ravichauhan3933]

very nice

[@humayfaragi2827]

Nice

[@AkhileshStudioB]

सर हिंदी में डिफेंडेंट शीट की एक वीडियो बना दीजिए सर प्लीज हेल्प मी

[@SagarKumar-pk4lk]

SIR - INDIRECT FUNCTION NOT WORKING AS INSTRUCTED IN YOUR VIDEO, PLS. HELP, SHOWING RESULT ONLY FOR FIRST COUNTRY

[@Arun_Peswani]

Thanks for another great video once again... I have a query here; as you have shown dependent list basis table headers, I have a task that I am not able to solve. There are many videos on youtube for this purpose, but the methods are very long and not simple like yours. The task is like I have State names in Column A, City names of these states in Column B, and Villages names of these cities in Column C. It becomes difficult then to make a dependent drop-down list in excel. Can you please help with any solution to this? It is a little bit complicated, I guess. States Cities Villages Rajasthan Jaipur Village-RJ1 Rajasthan Jaipur Village-RJ2 Rajasthan Alwar Village-RA1 Rajasthan Alwar Village-RA2 Haryana Ambala Village-HA1 Haryana Ambala Village-HA2 Haryana Rohtak Village-HR1 Haryana Rohtak Village-HR2

[@Myhobby.mycreation]

Sir, how to i select india and automatically show its state? In my which formula i could do this?

[@hasanmeeran5790]

Dear sir, app acha eexplain kiya ok thanks but one spelling mistake keral Kerala

[@amitde8876]

,,👍🏼👍🏼👍🏼

[@pankajknowledgeworld]

ish baar dependent drop down list ki ek aishi video banao.. jo puri detail main ho...condition niche di gai hai.. 1. main matlab user ek colom main gya jaha sirf customer ka name likh diya.. ab jab next colom main jaau then ush foam main dependent drop down list main sari value automatic aajaye .. bina list scroll karein.. aur ek badiya ek work book ki dusri sheet main table bani ho thodi smart view type user friendly .. ya ek work book main smart table data bana ho aur dusri work book ki work sheet main foam .. jaha bas ek customer ki drop down list select karo aur jo comman detail hoti h jaise like phone no ,address, reference name ,,uski firm ka name dusre colom automatic aajaye... bina scroll aur select ke... 2. aur jo dusri detail hai at all kisi main bhi underscore ka matter nahi ..ek proffessional dikhna chaiye.. 3. no vba... programming ka name sunte hi dimag main pathar padne lag jate hai.. ishliye no programming.

[@itisclearlymentionedthatti9365]

Koi formula ho to bataye, I am using iPad pro iPad excel me drop-down ke liye data validation nahi hai per formula kaam karta hai ..

[@kiranmanavachari3767]

Well taught sir.. problem ...The source currently evaluates to an error. What to do sir

[@rajugupta4518]

But sir another site nhi karna ho to select nhi hota hai please own country wala video bano . Ye video bhi nice hai

[@user-mw1th1le9m]

بہت اچھا بھائی ۔۔۔۔۔ کیا ہم آپ سے ایم ایس ورڈ میں فل ایبل فارم پر کوئی بھی سوال کر سکتے ہیں ۔۔۔۔جواب ضرور دینا شکریہ!!!!!!

[@falakfalak3853]

Hi, apki videos buhr informative hoti hain. Sir mujy ek problem aa rhi hy, jis tara ap ne countries names ki drop down list banae hy, ye name single hain, agr in names ko double kr den to pir ye without "underscore" accept nai hota. Ap plz ek dependent drop down list banaeay jis mai countries k name multiple hon like " Bangla Desh" or "United kingdom" in mai space hy es leay mai ne for example liky hain,, thanks

[@zainulabidinhussainkhan495]

Sir you have left to teach that if we create the same dependant drop list in row below so it will not work properly in the same manner

[@HeyYou-hy6zm]

Sir, how can I get a huge amount of data depending on dependent dropdown list? For example, Dropdown 1 : Class ( suppose class V) Dropdown 2 : Sec ( A/B/C) Now I want to get the datas of Class V ( any sec of my choice from dropdown) by clicking on a "Searchbox". Can this be possible? Plz let me know.

[@ComputerGyanGuruji]

yes

[@rajadey1552]

Sir main n ek cell m vlookup 4mula lagaya condition k sath. Ab me chahta hu jaha m vlookup lagaya waha ki condition fullfill ho to formula still rah jaye. Or condition exactly match nhi hoto me ek validation k through us cell ko specific message dena chahta hu.... Matlab sir formula and datavaildation ek sath kaam kare... Kya aisa ho sakta hai. Agar ap k paas koye vdo ho to plz link share kijiye na. Plz🙏🙏🙏🙏🙏🙏🙏

[@msquare2829]

Sir..ye to bs ek cell me drop down lagaya h baki k cell me bhi bar bar lagana padega kya

[@rajdeepbag]

Google sheet me dependant drop down list Kaise Ban sakta hai us per video banaaiye sar

[@asthaverma8268]

Sir State and city divide krne ke liye kaun as function use Kiya hai

[@ComputerGyanGuruji]

indirect or data validation

[@SurajPrajapati-jl9sm]

Sir, Please tell me haw can I make a drop list without duplicats in data validation

[@vedbulland5033]

Is there any way to contact you

[@MCLPATEL]

i try but shows reff error in Dependent Drop Down List In Excel,help me.

[@sonatt1]

CREATE FROM SELECTION HOW TO DO FROM OTHER SHEET

[@akcreation328]

Is video apne Jo search option lagaya o kaise?

[@sundarganjrupalicsundargan322]

Guruji MS Excel Download kaise kare ak video banaie

[@REGENTREEJU-vi5vl]

I didn't get the state name when I used =direct formula it shows error message#name

[@rohitkk7744]

Sir vba mai dependent drop down kesy banyae sir

[@atulmehta470]

Sir Can you help me to prepare drop down list with column head. Here you have explained with row header. I failing miserably to prepare drop down list by column header. Pl help.

[@zainulabidinhussainkhan495]

I can help you

[@zainulabidinhussainkhan495]

What do you want ?

[@atulmehta470]

Thanks for feedback Sir. Issue resolved now.

[@rangaanigubaar]

Ham kr rhy hain tho error aata hy.

[@sonalipahuja5090]

How to use this dropdown in other row

[@raghavpgvs2032]

Aap hume wo formula batao ager hum india select kere to India ke sare State aa jaye or next tab main jab koi ek state select kere too us state ke automatically district aa jaye...

[@R.KOFFICIAL1087]

The source currently evaluates to an error show kr rha hai

[@shivamvishwakarma2070]

Please help

[@WorkSpace-wt2oc]

What to do when there is a space in the Name of Name range?

[@pradnyakamble3958]

Add "_" between space

[@harishsuthar4276]

Sir मै excel में school सॉफ्टवेयर बना रहा हूँ और मेरे को एक समस्या है कि fee data वाली sheet में मेरा data है और मैं उसे आगे वाली शीट मैं कोई वाउचर बनाया है तो उसमें चाहता हूँ कि जैसे मैं वहाँ कोई class select करू तो मेरे को उसी class का सारा data show करे जैसे कि स्टूडेंट्स का पूरा डाटा ! दूसरी बात की जैसे की फीस स्लीप में और सारा डाटा show करवा लिया है पर मान लो कोई स्टूडेंट्स अपनी फीस कोई किसी माह में तो कोई किसी माह में तो fee slip मैं ऐसा कोनसा फॉर्मूला लगवा की fee sleep में वह ही डेटा show करे जिस माह में fee जमा हुई हैं ? विनती है जवाब जरूर देना

[@ComputerGyanGuruji]

bhai aap hamare ye video dekhen shayad aapki problem solve ho jayegi Part-1 kzbin.info/www/bejne/b36cY6Caia6Lgs0 part-2 kzbin.info/www/bejne/rHrZnJSJmdadecU

[@shivammaggo1709]

Still facing error. Please help.

[@bhammarprimaryschool829]

ગુજરાતી નામ drop down list બને

[@arvindmevalaljaiswal7234]

Dear Sir cell me hi agar type kare aur A B C D ke hisab se drop down list banti jaye. jaise mai IN type karu to INDIA, INDONESIA ya esse repleted sare name drop down list me dikhne lage aur jo hame chahiye uspar karsan klick karu to usi cell me o name aa jaye es par koi video ho to bataye. please.

[@ComputerGyanGuruji]

sure bhai

[@bachchuhaldar3783]

Sir... Bahut aacha hai, but mere se nehi ho raha hai... =Indirect (F2) dene par #REF! aaaa raha hai.. please solve this

[@souravneogi5465]

Same problem . =Indirect(select cell ) dene ke bad "the source currently evaluates to an error" dikha raha hai . Plz help me

[@biswajitkaran89]

Sir, this is only in one row but I want in multiple row. How is it possible?

[@ComputerGyanGuruji]

same process, try it

[@jiteshraut4599]

yes, i want multiple row. how to do ?

[@jagadishkumardas25]

Ise userform me kaise banaye

[@R.KOFFICIAL1087]

Sir nhi ho rha hai

[@nileshnandanwar04]

Sir... Ek Question tha... Please reply kijiye... KY eaise hi Sakta hai ki hum Google Drive pe kisi Ko PDF send kare... aur wo sirf dekh sake download nahi kar sake.... Agar ha to kaise... Please video banaye... Thank you

[@ComputerGyanGuruji]

bro aap apni pdf file par water mark laga kar protect karke upload karo varna agar ham chahen ki koi download na kar sake to wo uska screen shot le kar pdf convert kar sakta hai or google drive me read only ko option nahi hai

[@nileshnandanwar04]

@@ComputerGyanGuruji thank you

[@shivamvishwakarma2070]

Indirect function nahi lag raha

[@farazakram1084]

Sir iss formula ko undo kaisay krain ?

[@ComputerGyanGuruji]

jis cell me aapne data validation lagaya hai us cell par jayen or fir se data validation me jayen or clear all kar de

[@sanjayTECH04]

pakistan ka nam dena jaruri tha kya ..koi dusari country nahi mili..Excel Ustad

[@soumyadeeproymuhury9678]

Not working

[@kamalsarkar2100]

I like your videos but your English captions are irritating, nothing visible. Dislike it, make videos without captions.

[@atanuauddya6214]

that is not WEST BANGOL , IT would be " WEST-BENGAL "