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

Learn Excel awesome function INDIRECT tutorial step by step in Hindi with easy to understand explanation-How and when to use it.
1.What is Indirect function in excel
2. Excel INDIRECT function-Lookup values in different sheets
3. Excel INDIRECT Function-How it works and when to use it
4. How to use Indirect formula step by step tutorial in excel hindi
5.Excel Indirect function tutorial in hindi
Download the Practice Workbook here - Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#excelindirectfunction #indirectfunctioninexcel#Innozant #msexcel #indirectfunctionexplained

[@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.🙏❤️

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

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

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

[@bholaprasad4397]

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

[@Innozant]

God bless you dear..Keeo learning

[@shrikantbadge3978]

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

[@Innozant]

Thanks dear

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

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

[@shrikantbadge3978]

The Amazing channel. Amazing Teacher.

[@Innozant]

Thanks dear

[@shubhamsachdeva6969]

Thank you sir You are amazing 😇

[@Innozant]

Thanks dear

[@usmantahir1193]

Dude greetings from pakistan. You are the best

[@Innozant]

Thanks dear

[@tejpalsain1507]

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

[@Innozant]

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

[@tejpalsain1507]

@@Innozant हा जरूर।

[@samunsaifi3922]

Sir your every video is very helpful for Us 😊

[@SOHAILKHAN-xp3zv]

Sir bahut acche se samjhaya aapne

[@harshitshah7600]

Thanks this Video helped lot in performing daily job

[@Innozant]

❤️

[@riteshit]

SIR YOU ARE GOD

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

[@akak3585]

Nice video sirG thank you so much

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

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

[@AdityaModak]

Very useful and helpful. Thank you!

[@Learn_withkd]

Very informative Sir 👍👍👍

[@amollad3381]

Thank you ❤😊

[@AliKhan-vg5wr]

Excellent I love your explanation great keep it up brov

[@Innozant]

Thanks dear ❤️

[@moharirshyamsunder4879]

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

[@Innozant]

After some time

[@makk3480]

Amazing explanation!

[@Innozant]

Thanks

[@superNareshg]

Thank you sir ji.

[@Innozant]

Thanks ❤️🙏

[@Viishhal.]

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

[@Innozant]

Thanks Vishal Ji🙏❤️

[@deepsingh-pc9ly]

THANK YOU SIR

[@Veenu-yi7pc]

Amazing & Excellent

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

[@er.ajitverma6800]

thank you Sir, you are best

[@boyinasantoshkumar6995]

Very valuable Sir, Thankyou So much for this video

[@Innozant]

Thanks dear..❤️🙏Sukriya Dilse

[@msexcelgooglesheet374]

Something new learn in excel Indirect ❤️🙏👍

[@Innozant]

🙏👍❤️thanks Good Night

[@puransingh-sx2tk]

Josh alway high guru g ka😊👌🏻

[@Innozant]

Thanks Puran🙏❤️🙂

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

[@gauravbhatia7987]

Good sir indirect ko abb sikha asan hai

[@Innozant]

Thanks Gaurav Ji🙏❤️

[@meditationmusic6482]

So nice Sir ji

[@Innozant]

Thanks Sanoj🙏❤️

[@hemantgusain1260]

Thanks you sir

[@Innozant]

Thanks Hemant Ji🙏❤️

[@dipsundardutta2735]

Nice details vdeo

[@atiqrehman1223]

excellent

[@tarunsehgal5789]

Thanks, sir

[@Innozant]

Thanks Tarun Ji

[@jaindigitalinvitations]

Vow it's amazing

[@Innozant]

♥️👍

[@pawankumar-kx1lx]

Nice❤

[@anilande4304]

Thank you for function

[@Innozant]

You Anil.. Thanks for Support🙏♥️

[@RohitKumar-uy7cx]

Nice vedio sir ji

[@Innozant]

Thanks Rohit Ji🙏❤️

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

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

[@abhishekshirsekar2065]

Thanks a lot indirect function , offset function kab lavoge

[@Innozant]

Thanks...Dear jab indirect finish next topic offset

[@kmanoj392]

Good

[@umairaliumair6716]

Sir ap cube formula ka lecture BHI u tube par dalay

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

[@amazingindiabyshiva8357]

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

[@SSG_Channel]

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

[@tarunsachdeva3570]

Which software you use to record a video.

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@Harish.Prasad.Semwal]

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

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

[@kaaminikannoujia5730]

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

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

[@battlefansshorts8941]

👍👍

[@Innozant]

❤️🙏

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

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

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

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

[@kavitakanwar2161]

Sir innozant channel par sql language playlist hai kia

[@Innozant]

Abhi nahi hai dear

[@kavitakanwar2161]

@@Innozant ok sir

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

[@umairaliumair6716]

Sir am cube formula ka lecture bhi

[@satyaprasadnaik5792]

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

[@Innozant]

Already there ..in mos Interview cracker series

[@gauravs6389]

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

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

[@bishtlokesh1297]

Awsome ❤️

[@Innozant]

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

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

[@Unfiltered_ind]

Sir what is r1c1 style and a1stayle.

[@Innozant]

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

[@Unfiltered_ind]

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

[@786yash123]

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

[@tejindersingh8502]

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

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

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

[@shwetkumar1719]

Sir reference or value me anter kya hai?

[@Innozant]

Value constant and reference cell address..

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

[@adarsh1216]

Sir mujhe odd even kaise nikalte h please bta dijiye

[@madurgababueducationS60]

multiples vlookup advamce excel videoS uplod korun .

[@SOHAILKHAN-xp3zv]

Sir Excel array use

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

[@yasirkhan4729]

How to use the Exact formula with indirect?

[@Innozant]

Will add examples in upcoming videos

[@yasirkhan4729]

@@Innozant Thanks

[@SunainaAdhya]

All functions are volatile.

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

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

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

[@uniquemobiletipstricks7714]

आरती को नहीं भूल सकते sir😂

[@mr.knight7146]

Poor explanation.

[@sethushankaranmadhavanmadh6712]

Indirect not good

[@Innozant]

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