Excel INDIRECT Function Explained | Step by Step Excel INDIRECT Tutorial in Hindi

[@parul2002]

I was trying to fix something in my workautomation excel sheet for last 3 years. I just found it in this video. Thanks a lot for this video.

[@ajaykumar-hu3py]

i have been watching your video from last 7 hours

[@Innozant]

My Goodness ❤️🙏 No words.. Thanks for giving this much love... Recommend you to watch playlist Basic Excel onwards step by step till adv. excel.M sure you learn and enjoy the series.🙏❤️

[@srinivasbattula1863]

What a explanation. I saw many videos but, I could not understand. This is the best video to understand indirect. Thank u bro

[@Innozant]

Thanks Srinivas

[@99DENIMO]

Sir,jab se aapka channel subscribe Kiya hai gharwale excel ko meri second wife kehte hai, mene ab tak more than 100 ko link share Kiya hai.your teaching is so good

[@Innozant]

Hahahaha..very nice

[@rajendraraiswal7269]

Awesome sir my all the query and doubts of indirect formula to clear from this video very very thanks Guru ji...

[@hemantkumar-ny6yx]

Outstanding teaching style :) Thank you so much !!!

[@Innozant]

Thanks

[@tejpalsain1507]

Thanks for introduction Indirect function. अभी मुझे इसका बेसिक यूज़ ही आता है। Advace indirect का इंतजार रहेगा।

[@Innozant]

Aaaj concept aapko samjh aaya hoga aisa umeed karta hoon..🙏

[@tejpalsain1507]

@@Innozant हा जरूर।

[@shrikantbadge3978]

aa gaye hum firse revision karne. thank you sir amazing explanation.

[@Innozant]

Thanks dear

[@SOHAILKHAN-xp3zv]

Sir bahut acche se samjhaya aapne

[@bholaprasad4397]

sir aap Jo padhate aapka charan chhune ka dil kar raha hai

[@Innozant]

God bless you dear..Keeo learning

[@harshitshah7600]

Thanks this Video helped lot in performing daily job

[@Innozant]

❤️

[@samunsaifi3922]

Sir your every video is very helpful for Us 😊

[@shrikantbadge3978]

The Amazing channel. Amazing Teacher.

[@Innozant]

Thanks dear

[@Learn_withkd]

Very informative Sir 👍👍👍

[@AdityaModak]

Very useful and helpful. Thank you!

[@usmantahir1193]

Dude greetings from pakistan. You are the best

[@Innozant]

Thanks dear

[@shubhamsachdeva6969]

Thank you sir You are amazing 😇

[@Innozant]

Thanks dear

[@sandeepaswal8944]

Sir Excellent explanation to make use of indirect function. Sir lecture explanation and method is so good. You deserve a lot more likes for this well explained video. I appreciate your intelligent work.

[@Innozant]

Love you dear Sandeep...🙏❤️ For such a wonderful and lovely feeback..khud bhi seekhiye aur apno se share bhi kijiye wo bhi badhen aage life me.

[@satishojha6240]

Thanku sir thoda thoda samajh ayaa hai lekin jaise jaise aur example hoga tho pura clear ho jayega.good night sir

[@Innozant]

Haan .phirse dekhna ye first video repeat krke...basic jaroori hai.good night

[@meditationmusic6482]

So nice Sir ji

[@Innozant]

Thanks Sanoj🙏❤️

[@msexcelgooglesheet374]

Something new learn in excel Indirect ❤️🙏👍

[@Innozant]

🙏👍❤️thanks Good Night

[@akak3585]

Nice video sirG thank you so much

[@Viishhal.]

I made some experiments with basic concepts!! Maza aa gaya!!, Thank you sir

[@Innozant]

Thanks Vishal Ji🙏❤️

[@AnkitSingh-sy6mz]

sir pranaam...aapke vidoes mere liye margdarshk hain...bahut bahut bahut bahut bahut sahriday dandwat pranaam aapko...bs ek cheej khna chah rha hu ki jb bhi kisi function k baare me bataya karen aap to microsoft ne english me kya batya hai uske bjaay aap suddh hindi me apne saral aur sateek andaaj me samjhaya karen to aapki bahut kripya hogi..koti koti pranaam

[@Innozant]

Thanks Ankit ji...meri koshish yhi rhta h ki eaay to understand apko kara saken..aage bhi dhyan rakhenge dear

[@pradeepkumarsharma71]

Nice video Sir. I understand some basic about Indirect function, not completely. But, I believe I will understand from your next videos. Thanks for your videos which are very helpful!!! 🙂

[@Innozant]

Thanks Pradeep,Learn step by step Indirect Function series.Will try to make you understand this concept and able to use it .

[@pradeepkumarsharma71]

@@Innozant Thank you very much Sir🙂🙂🙂

[@makk3480]

Amazing explanation!

[@Innozant]

Thanks

[@boyinasantoshkumar6995]

Very valuable Sir, Thankyou So much for this video

[@Innozant]

Thanks dear..❤️🙏Sukriya Dilse

[@riteshit]

SIR YOU ARE GOD

[@darpansharma6136]

Amazing trainer, thanks for explaining it so minutely. In this manner we will not never forget

[@Innozant]

Thanks Darpan.. Really means a lot to me

[@AliKhan-vg5wr]

Excellent I love your explanation great keep it up brov

[@Innozant]

Thanks dear ❤️

[@Veenu-yi7pc]

Amazing & Excellent

[@moharirshyamsunder4879]

Sirji macro video... You are too good...

[@Innozant]

After some time

[@udaancomputerclass561]

Thank you sir, I am regularly watching your vedio and it's help us to enhance of our knowledge. I personally request you to please strat a series of user form, micro, VBA coding

[@Innozant]

Sure will start vba automation afyer power BI series

[@amollad3381]

Thank you ❤😊

[@er.ajitverma6800]

thank you Sir, you are best

[@superNareshg]

Thank you sir ji.

[@Innozant]

Thanks ❤️🙏

[@gauravbhatia7987]

Good sir indirect ko abb sikha asan hai

[@Innozant]

Thanks Gaurav Ji🙏❤️

[@puransingh-sx2tk]

Josh alway high guru g ka😊👌🏻

[@Innozant]

Thanks Puran🙏❤️🙂

[@deepsingh-pc9ly]

THANK YOU SIR

[@jaindigitalinvitations]

Vow it's amazing

[@Innozant]

♥️👍

[@anilande4304]

Thank you for function

[@Innozant]

You Anil.. Thanks for Support🙏♥️

[@umairaliumair6716]

Sir ap cube formula ka lecture BHI u tube par dalay

[@dipsundardutta2735]

Nice details vdeo

[@amazingindiabyshiva8357]

सर रेंज को हम बिना एम पर्सेंट लगाए कॉलन के साथ नहीं दे सकते क्या

[@SSG_Channel]

Sir i need help with indirect row column criteria which is not available on KZbin

[@hemantgusain1260]

Thanks you sir

[@Innozant]

Thanks Hemant Ji🙏❤️

[@cdobza3390]

hi, Innozant. I have an excel with various sheets. In each sheet, I have a same text in a cell and this text has different references. can I pull all that data from different sheets and put it in a column by entering that text in a new sheet

[@atiqrehman1223]

excellent

[@gamesworld_all]

Thank you very much sir

[@Innozant]

❤️🙏🙂 Thanks

[@MdIlyasShaikh]

Nice sir, thanks

[@Innozant]

Thanks Shaikh Sahab🙏❤️

[@ajaykumar-hu3py]

great job done bro

[@Innozant]

Thanks Ajay Ji🙏❤️GN dear.

[@devendradavande5369]

Thank you sir, Please make video on uses of Symbols in excel formulas

[@Innozant]

Sure dear

[@pawankumar-kx1lx]

Nice❤

[@tarunsehgal5789]

Thanks, sir

[@Innozant]

Thanks Tarun Ji

[@sushilshukla7296]

So nice 👍

[@Innozant]

Thanks Sushil ji.🙏❤️

[@suffyanehsan617]

If amount is positive then it will go in column A and if amount is negative then it goes column B

[@tarunsachdeva3570]

Which software you use to record a video.

[@abhishekshirsekar2065]

Thanks a lot indirect function , offset function kab lavoge

[@Innozant]

Thanks...Dear jab indirect finish next topic offset

[@RohitKumar-uy7cx]

Nice vedio sir ji

[@Innozant]

Thanks Rohit Ji🙏❤️

[@gauravs6389]

Why Ampersand used and double quotes for Colon while giving range ?

[@mikelennon1078]

Can you use this function in CRM ( One to Many) . i.e. I have several worksheets. One is the records of many Customers ( Companies), the second Contacts ( All employees who are working in each Company), third Invoice records. Each company may have zero to 100 invoices, forth sheet for all work orders (Each company may have zero to 100). The using Data Validation and Combo Box to select a company in a new sheet and upon doing this to see certain columns from other sheets. ( Name, Title, Email & Phone of its contacts), (Date, Invoice Number, Product, Value,..) from Invoices, same goes for Work orders and any other sheets. I would appreciate your input. Thank you

[@kmanoj392]

Good

[@kaaminikannoujia5730]

Can we use this in different files because it is not working?? Please confirm what we do

[@umairaliumair6716]

Sir am cube formula ka lecture bhi

[@786yash123]

मुझे vlookup से अगले सेल के उप्पर वाले सेल की वेलु चाहिए कैसे करे कृपिया मार्गदर्शन करे

[@ajaysaroha2539]

i hope you will upload offset part also asap then we can say that vlookup function part finnished.

[@Innozant]

Offcourse After Indirect will upload Offset part

[@bishtlokesh1297]

Awsome ❤️

[@Innozant]

❤️❤️❤️❤️🙏🙏 Thanks Lokesh ji

[@golubro9517]

Sir Me Aapki Video Bhot Pehle Se Dekh Raha Hu But Mene Yeh Dekha Hai Aap Apni Kisi Bhi Video Me Ye Nhi Bolte Kii Meri Video Like Kro Channel Ko Subscribe Kro Jabki Aap Apni Video Me Jee Jaan Laga Dete Hai Aur Aapka Concept Acche Se Bhi Samajh Me Aata Hai 😊

[@Unfiltered_ind]

Sir indirect ka use kaha pr use krte hai jayda tr ....

[@satyaprasadnaik5792]

Can we use indirect + match. Need a video for this.

[@Innozant]

Already there ..in mos Interview cracker series

[@RohitKumar-uy7cx]

Sir ek detail vedio excel wild card par bhi bnaiye indirect complete krne ke bad

[@Innozant]

Wild card Ka use excel text Function series me already bata rakha hai...waise alag se tips and tricks me bhi Hoga video..iska..phir bhi chahte Hain to bna denge 🙏❤️

[@RohitKumar-uy7cx]

@@Innozant thank you sir ji 🙏🙏🙏🙏 sir usme saare wild card ka kya kya practical use kr skte hai ye bhi details me bta dijiyega

[@anilkumarparmar1784]

Indirect me referance के तौर पे value le sakte hai ya nahi?

[@Innozant]

Reference as a text

[@anilkumarparmar1784]

@@Innozant kya value k base pe nahi ho sakta??

[@tejindersingh8502]

Can anyone tell me how to use an indirect address match together???

[@kavitakanwar2161]

Sir innozant channel par sql language playlist hai kia

[@Innozant]

Abhi nahi hai dear

[@kavitakanwar2161]

@@Innozant ok sir

[@Unfiltered_ind]

Sir what is r1c1 style and a1stayle.

[@Innozant]

Start your learning journey from playlist Basic excel..ye basic ke topic hain

[@shwetkumar1719]

Sir jam hm koi cell ka address double quotes me de rhe hai to ex- indirect("b18") iska meaning kya hai or agar hm indirect(b18) rakh rhe hai to eska mtlb kya h

[@Innozant]

Ecplained in video and your comment too❤️

[@adarsh1216]

Sir mujhe odd even kaise nikalte h please bta dijiye

[@Healthy-Wealthy43]

Sir , I am trying this but this formula takes value from same sheet .....I got error when call data from another sheet..I am following same example please do needful

[@Innozant]

Hi Shalini...Kindly note that indirect function need Reference as a text. Kindly check that you are passing reference only or reference as text . evaluate using F9

[@Viishhal.]

Sir, how could I automate cells.If my data is in tabular format

[@Innozant]

Using function ? And how you want to populate the data...@innozantofficial telegram id

[@Viishhal.]

@@Innozant sure sir

[@shwetkumar1719]

Sir Agar maine sheet ka name Arti Kumari kr dia hai fir maine iss formula ko lagaya fir ve ref error a rha hai kriya kr ke help kreya =SUM(INDIRECT("'"&C33&"'!e3:k3"))

[@Innozant]

Use samajh nhi aara hai ki sheet hai. Aap indirect me sheet define kariye..ek example hoga usme maine south africa wale sheet ke loye dekhiye lagaya h formula

[@shwetkumar1719]

@@Innozant ji sir islia maine Arti se Arti kumari kia fir =sum(indirect ("'"&c33&"'!e3:k3")) lagaya fir v nhi aaya

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@madurgababueducationS60]

multiples vlookup advamce excel videoS uplod korun .

[@shwetkumar1719]

sir agar sheet ka name maine aarti kumari kia fir cell se data kaise laege? =INDIRECT("'"&C33&"!"&E3) kya ya sahi hai agar me RAM KUMAR sheet ka name kia hu or E3 se value lana hai to sir? Arti name raha ya space nhi raha to a ja rha hai but plz space wale se kaise lay bataeya

[@Innozant]

Nahi galat hai...sheet ka ref bhi denge exclamation ❗ sign ke saath

[@battlefansshorts8941]

👍👍

[@Innozant]

❤️🙏

[@Harish.Prasad.Semwal]

7:40 9:12 or (10:32) 11:39 or (12:15)

[@SOHAILKHAN-xp3zv]

Sir Excel array use

[@shwetkumar1719]

Sir reference or value me anter kya hai?

[@Innozant]

Value constant and reference cell address..

[@ravi.mahour]

There is three Persons with name as 1. - RAVI, 2. - DEEPAK, AND 3. - VINOD. And the First one (RAVI) wants to inviite the third one (VINOD) in his Brother's marriage party. But condition is here, He (RAVI) don't want to call him (VINOD) directly but He (RAVI) wants to invite him (VINOD) as a name of friendship , So He (RAVI) call to the second one (DEEPAK) and ask him to call the third one (VINOD) to come in party. and then the second one (DEEPAK) calls to the third one (VINOD) And Finally the third one (VINOD) come in party. So Basically, it is the work of our beloved Excel's function - INDIRECT { like Dusra MAHARAJ🤴)

[@Innozant]

Very True...🙏😊❤️Bht baariki se samjha hai aapne concept ko..Love it🙏❤️

[@ravi.mahour]

@@Innozant Thank You Sir 😊😊

[@horrorlovestories]

Sir 11:13 pe reference error aa raha hai aur 7777 for aarti e3 value nahi aa raha- =INDIRECT(D30&"!"&D31) - i added this formula. Please help Sir I am stuck

[@Innozant]

kuch galat kar re hain..indirect waise hi use krnege jaise aap ydi us sheet par direct ydi Jake value uthayenge to kaisa reference hog wo check kijiye aur apply kijiye ek baar video phirse dekhke

[@horrorlovestories]

Sir mujhko error mil gaya. Woh aarti sheet pe name maine sheet 3 likha thaa isliye reference error aaya. Now its working fine and i am really excited to go ahead.

[@shwetkumar1719]

Sir indirect("b19") & indirect(b23) inme difference kya hai?

[@Innozant]

Bataya hai video me dear Shwet. Jab aap b23 wothout quote paas kr re ho that means us b23 me jis cell ka reference rakha hoga us cell par refirect hoga aur wo value layega..but duble quote me paas kiya hai to wo b19 me jo value hoga use leke aayega..aap practically is test krke dekhen

[@shwetkumar1719]

@@Innozant yes sir thank you🙏

[@yasirkhan4729]

How to use the Exact formula with indirect?

[@Innozant]

Will add examples in upcoming videos

[@yasirkhan4729]

@@Innozant Thanks

[@ajaykumar-hu3py]

shaw 1 to 17 interview series

[@Innozant]

Omg....in a single day🙂👍this is what the dedication is all about..Reherse all questions nom of times.. Interview me bahar se koi Ques. Aa hi nhi skta..I assure you...👍🙏 And I still can't believe it 😅

[@SunainaAdhya]

All functions are volatile.

[@PopatMomu]

Ye topic 2018 me hota to maja aa jata

[@Innozant]

❤️🙏😊

[@shreyansbaid4384]

Mujhe ref error dikha Raha hai @innozant

[@Innozant]

kyu?ref nhi aayega

[@shreyansbaid4384]

=indirect (a1&"!"&a1) isme indirect reference

[@shreyansbaid4384]

=indirect (a1&"!"&"a1") isme Sahi dikha Raha hai @innozant

[@shreyansbaid4384]

Sir plz kya mistake hai Sahi Kar do

[@shwetkumar1719]

=SUM(INDIRECT(C33&"!C34:C35")) Sir esko ess tarah sum q nhi a raha

[@Innozant]

Sahi to hai..kya issue?

[@shwetkumar1719]

@@Innozant sir fir v issue a rha

[@RohitKumar-wt8qy]

Sir indirect to bahut confused kar raha hai

[@Innozant]

Kyu Rohit..Ye to bht hi pyara function gai..complete tutorial indirect ke pehle finish kijiye..m sure aayega samajh..bht achese

[@dheerdalalme9642]

It is Dynamic and Static not Volatile and Involatile

[@Innozant]

Indirect function is semi volatile

[@sethushankaranmadhavanmadh6712]

Indirect not good

[@Innozant]

Why so...it's awesome finction if you are using with another function

[@mr.knight7146]

Poor explanation.

[@ShahBegumcomedy786]

Good evening sir Apna WhatsApp no dijiye sir