INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel

INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel
1. Dependent Dropdown List using Indirect Function
2. Dynamic Drop Down List Using Indirect
3. INDIRECT for Dynamic Lists
4. How to Create Dynamic (Changing) Drop-Down Lists in Excel Using INDIRECT
Excel lookup Functions Playlist Link - • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#dynamicdropdownlist#excelindirectfunction#Innozant #dependentdropdownlist #indirectinterviewquestions

[@deekshaagrawal6105]

Just saw add while watching your video where that girl was giving job to those, who have lost their jobs due to covid I must say you are doing the same thing even better bcoz you are making people job ready ... Thank you so much for very valuable training...👍

[@Innozant]

Oh thanks a lot actually you don't know but these words mean a lot to me as this path which I have chosen will ultimately guide you all to your destination I am just a sailor in the way I thank all those travellers who are staying with me in this wonderful journey ☺️ you all have been with me and I hope that I will enjoy your company from now onwards till the end I thank you from the bottom of my heart and this goes to all of my fellow travellers who are destined to achieve success!!!

[@KamalSingh-yt5rr]

Sure sir soon will share the excel sheet with you 👍

[@mercynik2019]

@@Innozant sir, please suggest me the future jobs which i will get if i explore and understand the excel much enough

[@amritathakur2036]

@@Innozant how can I lean speak English

[@amritathakur2036]

@@mercynik2019 i think Excel is enough if u are in best in this software

[@theabhishekshaww]

U r the best excel teacher in this world for me. U saved my job today by this video 💓 thank you so much. Please keep on posting videos.

[@Innozant]

Thanks dear...sure will upload more vidoes

[@ShubhamDubey-l5n]

❤❤ nice explained

[@sandeepaswal8944]

Sir Great video. This was a very helpful. Easy to follow, you explain at a decent speed. Thank you so much sir for sharing.

[@Innozant]

Thanks Sandeep..Hope you like the Dynamic Drop down list conceot based on indirect funcation and learn from there.🙏❤️

[@surajitmaji1348]

Hats off to you , really this help me a lot...

[@Innozant]

Thanks

[@shrikantbadge3978]

Ye sach me bohot powerful video hai sir. THanks

[@Innozant]

Thanks Shrikant

[@chandrasekharchakrabarty8860]

Hats off to your teaching style. I love teaching (though I am not a teacher), but really love and like the way you explain the topics. Salute. - CS Chakrabarty, Mumbai.

[@Innozant]

Thanks dear..Really means a lot to me

[@garudzeputkarshakade2697]

सर आप बहुत हि अच्छा सिखाते हो अगर कोई सवाल मेरे मन आता है तो उसका जवाब मुझे आपके विडीओ देखकर मिलता है .Thank you so much sir.

[@Innozant]

Thanks Ganeesh Ji..❤️🙏

[@heeren.9]

Excellent sirji 👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Hiren

[@gauravbanerjee7891]

Sir bahut interesting tha..

[@Innozant]

Thanks Gaurav❤️🙏

[@shrikantbadge3978]

Very powerful video sir. Thank you.

[@maryrosediaz7313]

I am working in my spreadsheet and lost the data validation formula this video suites what am looking for yet the language huhuhu please make one with subtitles 🥺

[@shrikantbadge3978]

Very powerful video sir.

[@aptrends3257]

Thank You Very Much Sir

[@knifeskillshorts]

we can use substitute with indirect for dynamic naming range

[@babameraj766]

Main isse 100% samajh gaya❤

[@rudingeorge]

Very useful video....❤

[@lassinianshinifunnyvlogs1215]

Many thanks for your trainings, very helpful

[@Innozant]

Thanks dear❤️

[@PopatMomu]

Bahot khoob

[@Innozant]

Thanks Dev❤️🙏

[@AnkitKashyap-tm9gj]

Very nice Sir!

[@irfandaud7380]

Great Video

[@umerkayani79]

Thanks Sir How to freez format of one cell, where we put in column, date n then dropdown change to value but value not changed...🧐

[@kashirmirza6483]

How to combine two rows in data validation list?

[@patternsdadar5610]

Sir in this video on 10.32 you have shown how to populate list in the cells instead of drop down list. I tried doing the same but I'm getting value error inspite of doing Ctrl + Enter. Can you help me out on this issue.

[@Innozant]

Using indirect function.you need to press ctrl+enter to populate data. Freeze the cell reference as well

[@patternsdadar5610]

@@Innozant Thanks! It did worked but with Ctrl+Shift+Enter

[@tejpalsain1507]

Such a great time for us. Thanks.

[@Innozant]

Thanks Tejpal Ji.umeed hai Pasand Aaya hoga apko Concept aur seekh rahe honge aap isse .

[@tejpalsain1507]

@@Innozant yes sir

[@sanjitpaul2953]

Great Sir. You have made INDIRECT function very useful to me. Thank you.

[@Innozant]

❤️❤️ thanks

[@simrankapoor6397]

Very nice 👌

[@Innozant]

Thanks Simran..Happy learning

[@bhoopendraraghav9781]

Very nice thanks sir....

[@Innozant]

Thanks Bhoopendra ..Umeed hai ab Indirect Concept samajh aane laga hoga

[@mraheel3484]

Pls requesting help as getting issue todue to underscore of naming ranges

[@asmrindia]

Great

[@Innozant]

Thanks Amit Ji🙏❤️

[@jaiyadav1256]

Excellent

[@Innozant]

Thanks Jai..Have a great day ahead

[@DIPGGG]

How to display common data from more than 5 lists whose column header is in a drop down menu

[@shonakmdheeraj7590]

Dear sir your videos are really awesome please keep it up effort and please make video on automatically vendor reconciliation also

[@Innozant]

Thanks..noted..give me some time

[@Harish.Prasad.Semwal]

1:11 3:04 5:23(Revision required) 10:14 11:35

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks Gaurav Ji.❤️

[@thankikamalkumar9841]

Drop Down works fine when both options are available within same sheet, however when it is available in separate sheets then don't work?

[@praveenkumar-jk4rm]

Sir drop down list me agar particular selection ke alawa all data kaise select Karen plz discribe

[@KamalSingh-yt5rr]

Just a great video !!! Enjoyed myself to learn something new thru this video. I've a question for you regarding drop down list. Suppose if I want to populate more than one item name in one particular cell using drop down...can you please help me out with this? It would be really helpful 🙏

[@Innozant]

Kindly share the sheet ..thanks🙏❤️

[@bachchuhaldar3783]

Great video.... ❤️❤️❤️ Sir I have a question...I have name list in another sheet... How to drop down list another sheet....?

[@Innozant]

Thanks dear.Thete is no isssue for the same

[@bachchuhaldar3783]

@@Innozant sir.. please provide your mail id.... Some problems send to you 🙏🙏🙏🙏

[@theasifarman]

Brother I am in trouble ...try to do a without drop down list using indirect...but like yours, it couldn't happen...

[@RahulRoy-po9ct]

🙏 SIR

[@rajnarayan1739]

Dynamic Drop Down List with auto refresh like first we chose county then auto refresh the state and block list.. please sir help me

[@AmitChandra_YouTube]

Thank you Sir for this video. I have a different problem, requesting for help. One Coloum (A) having Names, Next coloum (B) indicate Male or Female. And it is growing by the time. I need a dorpdown list in column C on Names only for males. How it could be done ? Please help .

[@Innozant]

Make a dynamic list based on male data extracted from dataset using filter function (if you are usinb office 365) Else will give you other solution for the same

[@AmitChandra_YouTube]

@@Innozant Thank you Sir for your kind response, I am using office 2019.

[@sachinkumarsachin9687]

Hi sit What is the shortcut key to Row Height and Coloum width in office 365

[@Innozant]

H for roe w foe width but best way shft spacebar

[@zzzzz644]

At 09:02 in video, how did you quickly converted BOOKS name into names with underscore. Please explain, is there any shortcut key for that?

[@Innozant]

Using substitute by removing space with underscore

[@zzzzz644]

@@Innozant thanks

[@zzzzz644]

@@InnozantWhen I am doing it, it always shows this message with error (THE SOURCE CURRENTLY EVALUTES TO AN ERROR. DO YOU WANT TO CONTINUE ?). Please help.

[@tradepro-jh1jl]

Different worksheet kaise kare

[@zzzzz644]

At 11:54, if I select any other cell other than beside the drop - drown list to populate the list data in the worksheet using INDIRECT it shows VALUE error. Why is that?? Just wanted to know.

[@ManpreetSingh-ko6mn]

same issue is with me. in 11:54 u say =Indirect(ref) then u say enter nahi ctr enter ??? what u say is not clear. shows error

[@mushtaqali267]

Janab ye jo vdo may ap nazr arahay hain is per bhee vdo bana dain

[@neeshusingh5908]

Sir Aapne ye naming range me _ kese liya h because me jab validation laga rha hu to _ ke sath to error aa rha hai (aThe source currently evaluates to an error.) Please help 🙏

[@kunalsharma2661]

Sir agr hum countriesm pehle india select krte h tab office wale column m india k records aa jayenge But agr usi time hum countries k column se india se german m move krte h tab bhi office wale column m india k last record jo select kiya tha vohi show hota h, agr hum dropdrop button select krte h tab germany k records show hote h Aisa kuch btaiye ki agr hum countries m india select kre to usi time office wale column m first record india k aaye then dropdown m saare records aaye

[@kunalsharma2661]

Or germany select kre to usi time germany k first record aye then dropdown button k baad saare records show ho

[@Innozant]

VBA ki jrurat pregi..data reset krne ke liye .

[@kunalsharma2661]

@@Innozant ok tnx sir

[@RajuSingh-df8hv]

I am confused that how it bring the list we made through IF, it can take the list from box given in question or what if we made the another list with same book name, does it take from that range as well. Sir, can you please make me understood the logic its worked to considering the list.

[@Innozant]

Why .kindly share your concern ,where you stuck now?

[@johndas8173]

Sir forcast formula ka video ka aayega sumifs sumproduct edate financial formula gst formula ke sath

[@Innozant]

Haan layenge iska bhi video dear jald.

[@tanmoy151]

KINDLY HELP ME I CANT APPLY INDIRECT (CELL ID) FORMULA

[@Innozant]

Why? Kindly share your Query

[@nishachauhan9103]

Sir , 11:48 me select list me indirect me Ctrl enter kee jagah Ctrl shift enter use kr sakte hai , please bataye

[@Innozant]

karke dekhiye..Nisha...ctrl enter isliye kyunki bulk array hai tadi single array function ko execute Karana hoga to ctrl +shift +enter krenge use.

[@nishachauhan9103]

@@Innozant ye tadi ka matlab kya hai jo aapne reply me use kiya hai

[@KamalSingh-yt5rr]

@@nishachauhan9103 tabhi

[@shaileshkumar-qf6bd]

Sir 2010 version me jis cell me formula hai wo #value! Show kar rha Aisa q, please help sir

[@Innozant]

Ctrl+shift +enter press kren

[@paramjeet975singh3]

Sir jab mai indirect se list highlight kar raha hu ctlrl + shift + enter se... Tab value to aa rahi hai magar jaha blank cell hai uski jagah 0 show kar raha hai..... Aur agar mai ctlr + enter use karta hu to Aadhi adhuri value aa raha hai?

[@Innozant]

Kaunsa excel version use kr re ho

[@paramjeet975singh3]

@@Innozant sir excel 2016 vo bhi original nahi hai.... Kyoki isme concate wala bhi formula nahi hau

[@motivationalshayarisneha1210]

Sir aap kaise underscore hain maine books ke name copy paste kr ke fir ek ek kr ke underscore dale toh drop down list me page number nhi aaya fir aapne jo underscore dale hin ussy ki toh list aa gya

[@Innozant]

Naming range de rakha hoga na dear..video phirse dekhiye aap..

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

[@Arun_Peswani]

Please let me known if you want a sample sheet for clarity. I am sure you will have a solution for my problem 😊

[@hirendrashriwas8021]

Sir jo last me aapne puri list populate bataye wo work nhi kr raha hai....#Value ! Error bata raha hai pls help

[@Innozant]

Wrong naming range le rahe hain aap

[@hirendrashriwas8021]

@@Innozant thank for guidance sir😊🙏

[@ManpreetSingh-ko6mn]

Sir ek chhoti si help kr do...pichle one month se pareshan hu drop down list me auto fill ke liye....har bar drop down list arrow pe click krne ki jrurat na pade ....me A type kru to usse related automatically fill ho jaye data... for eg if i type A the Ankit will automatically type if it has that name on data validation list. VBA try kr liya, Combo box try kar liya par kahi bhi help nhi mili. har ek video dekh li youtube pr, koi fayda nhi hua. har koi searchable dropdown list ke baare me bta rhe hai, par uske liye bhi apko dropdown arrow pe click krna pdega jo ki me nhi chahta....So plz help in this.

[@meenur1982]

Sir How can i download the Excel file

[@Innozant]

Hi Meenu..from anly latest video description,You may download Mis Master Practice file..and start your learning journey now

[@Radhe.mahant2010]

Indirect is not working in two workbook properly

[@Innozant]

Why ..Wht error shows.

[@Radhe.mahant2010]

When one work book is close than link using indirect is not working

[@Radhe.mahant2010]

@@Innozant I want dynamic link between two workbook book by using INDIRECT So that I can change link work book name any time

[@Radhe.mahant2010]

@@Innozant actually I make monthly data in one workbook And I want compair data for different month in different work book

[@chetan1008]

👍👍👍

[@vv9730]

11:50 control+enter se nhi aa rha..."#value" aa rha hain....

[@Innozant]

Ctrl+shift+enter

[@vv9730]

@@Innozant Thnx...how to remove zeros,in this...

[@nileshchavan742]

Hi sir,_ (underscore) karke name in range kaise tayar ki.

[@Innozant]

Default lag jata hai jab data validation me list lenge aur with space name lenge to

[@GarryChahalOFFICIAL]

The Source currently evaluates to an error. Do you want to continue का error आ रहा है भाई किया क्रू 😭

[@Innozant]

Kab aata hai error aur kya..kuch mistake kar re h ap steps mein

[@aakshiwadhwani6973]

Same error .. do you got it what the issue is ?

[@SagarKumar-pk4lk]

MY DYNAMIC LIST NOT WORKING

[@SagarKumar-pk4lk]

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

[@Monusingh-xi4vc]

Not Working Sir

[@Innozant]

Why..watch again

[@DesiMeowing]

Not clear

[@aldoseba]

Should change the title and add "in hindi" so people who don't understand don't waste their time with this.

[@Innozant]

These vudeo is foe hindi audience only

[@aldoseba]

@@Innozant I figured out that, and that's why it should be specified in the title.

[@pankubisht3495]

Sir jara aram se bolna chahiye jab tum shor key batate ho samjh me nhi ata or screen par bhi show kara karo

[@Innozant]

Dear Panku Yadi aap Basic Excel ke pehle video se mere lecture ko follow Kar rahe hote to sayad ye bolne ki jarurat hi Nahi Hoti..Kyunki ye shortcut bht detail me padha chuka hu dear..Aur Jo Index match seekh rahe Hain advance learner unse ye basic shortcut ki umeed trainer Kar sakta hai na..🙂😁Aapse gujarish hai ki yadi as Naye Jude Hain Innozant Channel se to Basic Excel Playlist se seekhna start kriye phir Advanced seekhen. Thanks for suggestions 🙏🙏🙏❤️❤️