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

[@TVSCDN]

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

[@hussainwarraich8139]

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

[@mudassirhussain1935]

Very Easily and live method is awesome

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

[@JaswantSinghBisht]

Great job sir

[@amiteducational4006]

Thanks... Aapka btane ka tarika best hai

[@jitendrabomble2218]

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

[@ComputerGyanGuruji]

Keep watching

[@mrinalbera5661]

Thanks sir for explaining

[@nadirazizaziz8172]

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

[@NoorAli71184]

❤❤very nice Iive long life

[@yogeerajswami8521]

Best

[@jaswantsinghtomar3694]

Bahut badiya

[@pronabdey5864]

Excellent Explained Sirji ,🙏

[@parthopratimdas175]

Thank you sir

[@walimuhammad.ch2020]

Thank you

[@humayfaragi2827]

Nice

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

[@ravichauhan3933]

very nice

[@bijaytanty8434]

Thanks Sir 🙏

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

[@kiranmanavachari3767]

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

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

[@msquare2829]

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

[@Myhobby.mycreation]

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

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

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

[@عمراناحمد-م9ط]

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

[@SagarKumar-pk4lk]

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

[@hasanmeeran5790]

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

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

[@AkhileshStudioB]

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

[@rajugupta4518]

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

[@rajdeepbag]

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

[@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
ruclips.net/video/9M92mdTIXLk/видео.html
part-2
ruclips.net/video/vIvkaSdqjCc/видео.html

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

[@SurajPrajapati-jl9sm]

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

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

[@MCLPATEL]

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

[@WorkSpace-wt2oc]

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

[@pradnyakamble3958]

Add "_" between space

[@REGENTREEJU-vi5vl]

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

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

[@asthaverma8268]

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

[@ComputerGyanGuruji]

indirect or data validation

[@akcreation328]

Is video apne Jo search option lagaya o kaise?

[@rohitkk7744]

Sir vba mai dependent drop down kesy banyae sir

[@sonatt1]

CREATE FROM SELECTION HOW TO DO FROM OTHER SHEET

[@amitde8876]

,,👍🏼👍🏼👍🏼

[@R.KOFFICIAL1087]

The source currently evaluates to an error show kr rha hai

[@vedbulland5033]

Is there any way to contact you

[@sonalipahuja5090]

How to use this dropdown in other row

[@sundarganjrupalicsundargan322]

Guruji MS Excel Download kaise kare ak video banaie

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

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

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

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

[@rangaanigubaar]

Ham kr rhy hain tho error aata hy.

[@shivammaggo1709]

Still facing error. Please help.

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

[@R.KOFFICIAL1087]

Sir nhi ho rha hai

[@jagadishkumardas25]

Ise userform me kaise banaye

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

[@bhammarprimaryschool829]

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

[@shivamvishwakarma2070]

Indirect function nahi lag raha

[@soumyadeeproymuhury9678]

Not working

[@shivamvishwakarma2070]

Please help

[@sanjayTECH04]

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

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