Excel INDIRECT Function Sheet References | How to use INDIRECT to Reference Sheets

[@VlogShack16-kl4zo]

I will recommend this channel to everyone who wants to learn Excel. Bcoz I have also learn so many things in Excel from you in very easy and better way.

[@Innozant]

Thanks.Really means a lot to me

[@fitnesscreator8317]

Bhai reality bta rha hu Millions of videos m se koi ek video like krta hu. M Lekin ek number smjhaya apne God bless u 😊

[@Innozant]

Really means a lot to me God bless you dear

[@Taris376]

Sir aapki video ki wajah se meri accounts job me productivity increase huyi hai Kafi assani se me tarike dhund leta hu 👍👍👍👌👌👌 Thanks a lot

[@Innozant]

Good

[@khaled_ahmed_joglu]

Excellent sir. I m from Bangladesh. Your explanation is very clear.

[@Innozant]

Thanks Khaled sahab..Happy learning dear..God bless you

[@ankitmehra3074]

you teach better than those teachers who charge thousands of rupees. and the way you explain each and everything its marvelous.

[@Innozant]

Thanks Ankit. Ji.God bless You..happy learning ❤️ dear

[@hemantgusain1260]

Sir, you have amazing knowledge of excel. It is really helpful for us.

[@ajaysaroha2539]

Second lecture on indirect 😘😘😘 Thank you so much sir

[@Innozant]

You welcome Ajay Ji...🙏♥️ yes Learn it Now 👍

[@shrikantbadge3978]

Sir class karne me maja aata hai. I was revising Indirect as I forgotten it a little. Remembering old days. 💯🎂👏

[@Innozant]

That's great...Keep learning and exploring new things

[@SandeepRawat-zn7ov]

Sir you are best teacher for Excel 👍👍👍👍👍

[@Innozant]

Thanks Rawat sahab for your appreciation

[@poojarana2675]

I tried to apply this formula before but couldn't understand. You explained it very well. Thanks!

[@Innozant]

Thanks Pooja..Keep learning.Gid bless you..♥️

[@NandKishor-jm1td]

Thank u sir u have changed me u r such good teacher nd well wisher for youth ☺️

[@Innozant]

Thanks Sanu.Have a wonderful career ahead ♥️

[@sandeepaswal8944]

Sir You are an amazing tutor!! Your channel must be one of a kind in teaching MS excel. Appreciate very much.

[@Innozant]

Th Sandeep..Your name I never forget as my true student...and always appreciate my hard work..🙏♥️👍Lots of love dear..🙏

[@lenovolaptop5482]

full concept clarity video❤

[@asimali5820]

Thank you sir, You have solved my problem!

[@kkrcreationstatus6583]

Thank you, sir.....Extraordinary functions ko samjhane ke liye Pls, Bhai Log Share Karo

[@sanjeevkhakre2990]

Sir like your videos. I learned a lot of new excel function. Thank you so much

[@Innozant]

Thanks Sanjeev Ji♥️👍🙏

[@abhishekshirsekar2065]

Ur owsome sir I have got lot deep knowledge from u regarding xcel🙏🙏🙏🙏🙏

[@Innozant]

Thanks Abhishek Ji👍♥️🙏Happy Learning♥️👍 Good Night

[@simrankapoor6397]

Extremely beautiful video... superb 👌

[@Innozant]

Thanks dear❤️

[@satishojha6240]

Great sir concept clear ho raha hai thanku sir.good night

[@Innozant]

Thanks Satish Ji..Haan Hoga clear dheere dheere..good night 👍♥️🙏

[@munshirasim7188]

Outstanding Video, Thanks sirji

[@excelforeveryone2657]

Really a awesome videos for a excel learner. 👍👍👍

[@Innozant]

Thanks dear

[@atiqurrahman1962]

Thank you very much for this amezing tutorial. Sir would you like to help me, how to get data from multiple sheets as like a summary? Plz help me.

[@cartoonloversop6019]

Sir Really very useful function hai ye indirect suppppppper

[@Innozant]

Thanks dear.Happy learning dear

[@SumitSharma-rc6uj]

thanks sir very use full video for all students

[@Innozant]

Thanks Sumit,M trying my best to deliver best content in sequence step by step

[@pravinkumbhare1750]

Very useful Sir..

[@ganeshkishorsonwani_1432]

Thanks sir... You are great...

[@Innozant]

Thanks Ganesh Ji...Have a greay day

[@puneetkatyal4290]

very good session

[@pramodkumar-ke8gd]

Great Sir, it's very useful for me

[@Innozant]

Thanks Pramod Ji..❤🙏

[@rameshchandgoswami7532]

Very nice style sir

[@rjraviraftarup7553]

tahe Dil se shukriya sir Apka

[@Innozant]

Aapko bhi sukriya ..mehnat krne ke liye..👍🙏♥️

[@kinghundred]

very excellent sir

[@akak3585]

Nice video sirG thank you so much

[@AnujSaini-b6w]

sir your teaching better

[@vikasgawaria5330]

Sir aapke mukh se jaadu waale video sunker hansi aa jati hai and this video was nice and good morning

[@Innozant]

Hahahaha... Happy learning ❤️😅

[@user-jc6te1vm8v]

as usual again awsome class by u sir.... bt still wondering why we need that indirect function.. bcoz i believe all the pulling of data can be handled by those native lookup functions perfectly.... thinking that just for the sake of including another function, it's there in excel.... nevertheless amazing class by u sir....

[@Innozant]

Dear wait for 2 or 3 more videos to come then you may able to see the beauty of indirect funcation.

[@user-jc6te1vm8v]

@@Innozant even if that's not the case, simply love the way u teaches.... u remind me of my golden childhood period when teacher taught with thier heart nd soul

[@swapnaghosh5028]

Sir your are great 👍 also your smile

[@Innozant]

Thanks Swapna..Keep Learning ❤️

[@rajeshghai1494]

You r great teacher❤️❤️

[@Innozant]

Thanks Rajesh Ji🙏❤️

[@shubhamkumardubey6571]

Very nice sir

[@tejpalsain1507]

Superb sir. Thanks

[@Innozant]

Thanks Tejpal Ji

[@msexcelgooglesheet374]

True line Other KZbinr: Today excel magic (one video in a month) And Innozant Sir Ji: We are teaching excel in sequence not making houch pouch (daily free excel classes❤️ with full dedication and punctual ❤️) 🙏😀😂.

[@Innozant]

Love You♥️🙏for such a true and wonderful comment...♥️🙏

[@SamarpanaSingh-i9h]

whenever I meet a new bee in corporate world I ask them to just go through Dilip Jha Sir Video without a doubt.

[@Innozant]

Thanks Samar.Krep growing..God bless you

[@ramseshu110]

Good sir 👍 . I have small doubt VBA or powerquery which is better for automation

[@Innozant]

Are both are different things dear...power query is a tool ..VBA is programming language for automation...

[@aamirmasood4655]

Tussi great ho jee..

[@Innozant]

Thanks Aamir Masood Sahab. Good Morning.hv a great day🙏🙏🙏❤️❤️❤️👍👍👍

[@aamirmasood4655]

@@Innozant Shukriya Jee..Good morning to you as well,

[@aqeelahmadengr3]

Good work.

[@Innozant]

Thanks ..Must watch today's Interview cracker special episode..❤️🙏👍

[@atulshukal4072]

Very good Sir ji

[@Innozant]

Thanks Atul Ji❤️🙏

[@motivationalshayarisneha1210]

Sir indirect is vry interesting 😊

[@Innozant]

👍❤️

[@pradeepnegi7523]

Happy holi sir

[@Innozant]

Happy Holi Negi Ji

[@MukeshSingh-kv4pn]

Good video 👍👍👍

[@Innozant]

Thanks dear

[@rjraviraftarup7553]

Excellent sir 👍

[@Innozant]

Thanks dear Ravi👍🙏♥️

[@munendrarathore01]

Wah Bhai ji..

[@gauravbhatia7987]

Thnq sir so much

[@Innozant]

You welcome 👍♥️🙏

[@chetankumar6191]

Dear Sir, your technique is amazing but I would like to suggest you, please zoom spreadsheet whenever you describe formula as it is not proper visible and become confusing to understand. I have subscribed your channel. Thanks a lot for sharing such type of valuable information....

[@Innozant]

Thanks Chetan for your valuable appreciation and suggestions. Yes you may see the changes in our latest videos.👍♥️ These are old videos when I was not that much aware with video editing 🙂

[@awesshaikh716]

Thanks sir..

[@Innozant]

You welcome Awes♥️🙏

[@mukul2072]

Sir work book me kese use karege

[@rjraviraftarup7553]

👍👍👍👍👍

[@mushtaqali267]

Salam i am from karachi Pakistan ap jo screen per nazr arahay hain ek dam clear iska ek vdo bana dain

[@Innozant]

Ye to simple hai..kisi bhi video editing me screen overlap ka option hota hai dear❤️

[@chetan1008]

👍👍👍

[@sunilkumar0245]

can you tell me , why i am not able to see the image function on excel (office 365)

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@tarunmaiti8209]

Sir i am using =indirect(cell no) space indirect(cell no) enter but it is not working. Does it work in excel 2007?

[@RahulRoy-po9ct]

🙏

[@rjraviraftarup7553]

⭐⭐⭐⭐⭐

[@kunalsharma2661]

Sir ky hemant or jun k cell refrence se bhi output aa skta h ky Eg. Hemant h (C3) mai Or jun h (D2) mai =C3 D2 ho skta h ky Mujhe ye to pta h ki aapne top row or left column k naming range se kiya h Isse to output correct aa raha h But mujhe sirf itna hi dout h Ki hemant or jun k cell ref.se bhi ho skta h ky???

[@Innozant]

Haan reference jiska paas karenge value aayega .but dono ke liye indirect lagana Hoga seprate

[@yashpatil3375]

Very nice sir ji 👍

[@KumarRahul-pk1dd]

i want to search excel sheet convert to web app

[@deepakchauhan4974]

Sir apne is video me indirect fucntion ki madad se different worksheet ke value ko sum karna sikhaya, lekin mera query ye hai ki sir agar sum value different rows me ho tab to ye kaam nahi karega na ,

[@Innozant]

Different row me ho to dynamic range using offest is good option,aur index se bhi kar skte hain rrow data ke base par bhi

[@deepakchauhan4974]

@@Innozant aisa video aage is series me hai kya, mujhe nahi lagta hai ki hai

[@sandeepchavan455]

Mere ko indirect with vlookup lagana hai magar work book close ho to bhi wo work karan chahiye.

[@Harish.Prasad.Semwal]

1:05 2:21 3:15 5:47 6:12

[@Innozant]

Kindly share your query

[@Harish.Prasad.Semwal]

@@Innozant Thanks sir, I am marking this for daily revision of formula taught by you.

[@Radhe.mahant2010]

Link close work book by indirect formula pr banaye

[@Innozant]

Ok Radhhe ji..Noted

[@deenabandhudevasthanam6545]

Namaste ji kindly let me know one thing in sheet1 column A, Last row value is =INDIRECT("A"&COUNTA(A:A),TRUE).. How to bring this to sheet2 using INDIRECT FORMULA ? Kindly let me know.. Namaste My name is Anil

[@Innozant]

You may pass jndirect formula in another sheet and give the reference sheet 1 .

[@shwetkumar1719]

Sir esme apne range ko ":" q nhi lia? Jaise aapne Arti wale worksheet me range lia to isme aapne bina ":" q lia sir?

[@Innozant]

Us cell me already value sum krke rakha hua haina

[@shwetkumar1719]

kaise sir hmlg to sum nikal rhe hai na jaise =SUM(INDIRECT(C33&"!"&C34&":"&C35)) iss formula se

[@sudeshjadhav8838]

Sir ji vlookup mai indirect formula add karna ho to kaise kare

[@Innozant]

Hai already video lookup and referene series me dear❤️

[@sudeshjadhav8838]

@@Innozant isme aapne sum formula dikhaya muze mila shayad maine galat likha hoga

[@sudeshjadhav8838]

False ka option ) close

[@akashkumar-oi1fw]

sir is example mai jo sinn hai like """" iss type ke ye samaj nahi a rahe koi dusre tarike se bata do jisse confusion na ho

[@Innozant]

Akash ..wo concept asaan to hai..aap ek kaam kijiye pehle What if Analysis playlist me Jake hyperlink Ka video dekhiye Ek Baar ye concept apke clear ho jayenge

[@pawanwakale8801]

Sir jab hum Indirect use kar rahe toh #REF! error aa raha

[@Innozant]

That means reference galat le rhe hain..naming range ydi liya hai aise check kijiye

[@deepikasandal1831]

The answer for hemant jun is wrong. It should be 2588 instead of 747

[@PankajSingh0943]

Kuch zydha hi Samja diya. Indirect Samaj nhi aa raha 😅😅

[@stevenmichael9547]

Video isnot clear

[@Innozant]

Again check dear..may be your internet issues..

[@sethushankaranmadhavanmadh6712]

Indirect dhokkevaz hain. Don't use it

[@Innozant]

It is good and time saving function,Use it with caution as it recalculate the worksheet.