Тёмный

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

Подписаться
Просмотров 80 тыс.
% 1 597

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.com/file/d/1SG7-ZGSJMUxpZ9l-j1AaQ2KQAzPEh8RG/view?usp=sharing
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)
drive.google.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P
Website - "www.innozant.com"
Let's Connect:
Instagram ► innozantoffi...
Facebook ► innozant
Twitter ► innozant
Linkedin ► www.linkedin.com/company/inno...
Telegram►@Innozantofficial
#excelindirectfunction #indirectfunctioninexcel#Innozant #msexcel #indirectfunctionexplained

Опубликовано:

 

19 ноя 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 180   
@ajaykumar-hu3py
@ajaykumar-hu3py 3 года назад
i have been watching your video from last 7 hours
@Innozant
@Innozant 3 года назад
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
@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
@99DENIMO 2 года назад
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
@Innozant 2 года назад
Hahahaha..very nice
@rajendraraiswal7269
@rajendraraiswal7269 2 года назад
Awesome sir my all the query and doubts of indirect formula to clear from this video very very thanks Guru ji...
@darpansharma6136
@darpansharma6136 2 года назад
Amazing trainer, thanks for explaining it so minutely. In this manner we will not never forget
@Innozant
@Innozant 2 года назад
Thanks Darpan.. Really means a lot to me
@er.ajitverma6800
@er.ajitverma6800 3 месяца назад
thank you Sir, you are best
@srinivasbattula1863
@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
@Innozant Год назад
Thanks Srinivas
@harshitshah7600
@harshitshah7600 2 года назад
Thanks this Video helped lot in performing daily job
@Innozant
@Innozant 2 года назад
❤️
@AdityaModak
@AdityaModak Год назад
Very useful and helpful. Thank you!
@boyinasantoshkumar6995
@boyinasantoshkumar6995 3 года назад
Very valuable Sir, Thankyou So much for this video
@Innozant
@Innozant 3 года назад
Thanks dear..❤️🙏Sukriya Dilse
@aptrends3257
@aptrends3257 2 года назад
Thank you Sir Very Much
@sandeepaswal8944
@sandeepaswal8944 3 года назад
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
@Innozant 3 года назад
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.
@SOHAILKHAN-xp3zv
@SOHAILKHAN-xp3zv Год назад
Sir bahut acche se samjhaya aapne
@msexcelgooglesheet374
@msexcelgooglesheet374 3 года назад
Something new learn in excel Indirect ❤️🙏👍
@Innozant
@Innozant 3 года назад
🙏👍❤️thanks Good Night
@samunsaifi3922
@samunsaifi3922 5 месяцев назад
Sir your every video is very helpful for Us 😊
@Veenu-yi7pc
@Veenu-yi7pc Год назад
Amazing & Excellent
@hemantkumar-ny6yx
@hemantkumar-ny6yx 5 месяцев назад
Outstanding teaching style :) Thank you so much !!!
@Innozant
@Innozant 5 месяцев назад
Thanks
@shrikantbadge3978
@shrikantbadge3978 7 месяцев назад
aa gaye hum firse revision karne. thank you sir amazing explanation.
@Innozant
@Innozant 7 месяцев назад
Thanks dear
@akak3585
@akak3585 2 года назад
Nice video sirG thank you so much
@usmantahir1193
@usmantahir1193 10 месяцев назад
Dude greetings from pakistan. You are the best
@Innozant
@Innozant 10 месяцев назад
Thanks dear
@AnkitSingh-sy6mz
@AnkitSingh-sy6mz 3 года назад
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
@Innozant 3 года назад
Thanks Ankit ji...meri koshish yhi rhta h ki eaay to understand apko kara saken..aage bhi dhyan rakhenge dear
@riteshexcel
@riteshexcel Месяц назад
SIR YOU ARE GOD
@pradeepkumarsharma71
@pradeepkumarsharma71 3 года назад
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
@Innozant 3 года назад
Thanks Pradeep,Learn step by step Indirect Function series.Will try to make you understand this concept and able to use it .
@pradeepkumarsharma71
@pradeepkumarsharma71 3 года назад
@@Innozant Thank you very much Sir🙂🙂🙂
@kinghundred
@kinghundred 3 года назад
very excellent sir
@Viishhal.
@Viishhal. 3 года назад
I made some experiments with basic concepts!! Maza aa gaya!!, Thank you sir
@Innozant
@Innozant 3 года назад
Thanks Vishal Ji🙏❤️
@amollad3381
@amollad3381 Год назад
Thank you ❤😊
@udaancomputerclass561
@udaancomputerclass561 3 года назад
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
@Innozant 3 года назад
Sure will start vba automation afyer power BI series
@deepsingh-pc9ly
@deepsingh-pc9ly Год назад
THANK YOU SIR
@shrikantbadge3978
@shrikantbadge3978 Год назад
The Amazing channel. Amazing Teacher.
@Innozant
@Innozant Год назад
Thanks dear
@makk3480
@makk3480 Год назад
Amazing explanation!
@Innozant
@Innozant Год назад
Thanks
@dipsundardutta2735
@dipsundardutta2735 Год назад
Nice details vdeo
@superNareshg
@superNareshg 3 года назад
Thank you sir ji.
@Innozant
@Innozant 3 года назад
Thanks ❤️🙏
@atiqrehman1223
@atiqrehman1223 Год назад
excellent
@bholaprasad4397
@bholaprasad4397 10 месяцев назад
sir aap Jo padhate aapka charan chhune ka dil kar raha hai
@Innozant
@Innozant 10 месяцев назад
God bless you dear..Keeo learning
@cdobza3390
@cdobza3390 2 года назад
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
@AliKhan-vg5wr
@AliKhan-vg5wr 2 года назад
Excellent I love your explanation great keep it up brov
@Innozant
@Innozant 2 года назад
Thanks dear ❤️
@sunnyrai6113
@sunnyrai6113 2 года назад
Thanks sir
@shubhamsachdeva6969
@shubhamsachdeva6969 2 года назад
Thank you sir You are amazing 😇
@Innozant
@Innozant 2 года назад
Thanks dear
@ajaykumar-hu3py
@ajaykumar-hu3py 3 года назад
great job done bro
@Innozant
@Innozant 3 года назад
Thanks Ajay Ji🙏❤️GN dear.
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Good sir indirect ko abb sikha asan hai
@Innozant
@Innozant 3 года назад
Thanks Gaurav Ji🙏❤️
@anilande4304
@anilande4304 3 года назад
Thank you for function
@Innozant
@Innozant 3 года назад
You Anil.. Thanks for Support🙏♥️
@gamesworld_all
@gamesworld_all 3 года назад
Thank you very much sir
@Innozant
@Innozant 3 года назад
❤️🙏🙂 Thanks
@pawankumar-kx1lx
@pawankumar-kx1lx Месяц назад
Nice❤
@puransingh-sx2tk
@puransingh-sx2tk 3 года назад
Josh alway high guru g ka😊👌🏻
@Innozant
@Innozant 3 года назад
Thanks Puran🙏❤️🙂
@MdIlyasShaikh
@MdIlyasShaikh 3 года назад
Nice sir, thanks
@Innozant
@Innozant 3 года назад
Thanks Shaikh Sahab🙏❤️
@satishojha6240
@satishojha6240 3 года назад
Thanku sir thoda thoda samajh ayaa hai lekin jaise jaise aur example hoga tho pura clear ho jayega.good night sir
@Innozant
@Innozant 3 года назад
Haan .phirse dekhna ye first video repeat krke...basic jaroori hai.good night
@moharirshyamsunder4879
@moharirshyamsunder4879 3 года назад
Sirji macro video... You are too good...
@Innozant
@Innozant 3 года назад
After some time
@tejpalsain1507
@tejpalsain1507 3 года назад
Thanks for introduction Indirect function. अभी मुझे इसका बेसिक यूज़ ही आता है। Advace indirect का इंतजार रहेगा।
@Innozant
@Innozant 3 года назад
Aaaj concept aapko samjh aaya hoga aisa umeed karta hoon..🙏
@tejpalsain1507
@tejpalsain1507 3 года назад
@@Innozant हा जरूर।
@meditationmusic6482
@meditationmusic6482 3 года назад
So nice Sir ji
@Innozant
@Innozant 3 года назад
Thanks Sanoj🙏❤️
@golubro9517
@golubro9517 2 года назад
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 😊
@devendradavande5369
@devendradavande5369 2 года назад
Thank you sir, Please make video on uses of Symbols in excel formulas
@Innozant
@Innozant 2 года назад
Sure dear
@tarunsehgal5789
@tarunsehgal5789 3 года назад
Thanks, sir
@Innozant
@Innozant 3 года назад
Thanks Tarun Ji
@jaindigitalinvitations
@jaindigitalinvitations Год назад
Vow it's amazing
@Innozant
@Innozant Год назад
♥️👍
@RohitKumar-uy7cx
@RohitKumar-uy7cx 3 года назад
Nice vedio sir ji
@Innozant
@Innozant 3 года назад
Thanks Rohit Ji🙏❤️
@SSG_Channel
@SSG_Channel Год назад
Sir i need help with indirect row column criteria which is not available on RU-vid
@amazingindiabyshiva8357
@amazingindiabyshiva8357 Год назад
सर रेंज को हम बिना एम पर्सेंट लगाए कॉलन के साथ नहीं दे सकते क्या
@kmanoj392
@kmanoj392 Год назад
Good
@chetan1008
@chetan1008 2 года назад
👍👍👍
@sushilshukla7296
@sushilshukla7296 3 года назад
So nice 👍
@Innozant
@Innozant 3 года назад
Thanks Sushil ji.🙏❤️
@suffyanehsan617
@suffyanehsan617 2 года назад
If amount is positive then it will go in column A and if amount is negative then it goes column B
@meriawaazhindi5217
@meriawaazhindi5217 Год назад
❤️❤️❤️❤️❤️
@mikelennon1078
@mikelennon1078 3 года назад
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
@battlefansshorts8941 3 года назад
👍👍
@Innozant
@Innozant 3 года назад
❤️🙏
@umairaliumair6716
@umairaliumair6716 2 года назад
Sir ap cube formula ka lecture BHI u tube par dalay
@ajaysaroha2539
@ajaysaroha2539 3 года назад
i hope you will upload offset part also asap then we can say that vlookup function part finnished.
@Innozant
@Innozant 3 года назад
Offcourse After Indirect will upload Offset part
@abhishekshirsekar2065
@abhishekshirsekar2065 3 года назад
Thanks a lot indirect function , offset function kab lavoge
@Innozant
@Innozant 3 года назад
Thanks...Dear jab indirect finish next topic offset
@gauravs6389
@gauravs6389 Год назад
Why Ampersand used and double quotes for Colon while giving range ?
@tarunsachdeva3570
@tarunsachdeva3570 11 месяцев назад
Which software you use to record a video.
@umairaliumair6716
@umairaliumair6716 2 года назад
Sir am cube formula ka lecture bhi
@kaaminikannoujia5730
@kaaminikannoujia5730 2 года назад
Can we use this in different files because it is not working?? Please confirm what we do
@786yash123
@786yash123 Год назад
मुझे vlookup से अगले सेल के उप्पर वाले सेल की वेलु चाहिए कैसे करे कृपिया मार्गदर्शन करे
@madurgababueducationS60
@madurgababueducationS60 2 года назад
multiples vlookup advamce excel videoS uplod korun .
@SOHAILKHAN-xp3zv
@SOHAILKHAN-xp3zv Год назад
Sir Excel array use
@satyaprasadnaik5792
@satyaprasadnaik5792 3 года назад
Can we use indirect + match. Need a video for this.
@Innozant
@Innozant 3 года назад
Already there ..in mos Interview cracker series
@bishtlokesh1297
@bishtlokesh1297 3 года назад
Awsome ❤️
@Innozant
@Innozant 3 года назад
❤️❤️❤️❤️🙏🙏 Thanks Lokesh ji
@shwetkumar1719
@shwetkumar1719 3 года назад
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
@Innozant 3 года назад
Ecplained in video and your comment too❤️
@Unfiltered_ind
@Unfiltered_ind 2 года назад
Sir indirect ka use kaha pr use krte hai jayda tr ....
@adarsh1216
@adarsh1216 2 года назад
Sir mujhe odd even kaise nikalte h please bta dijiye
@Unfiltered_ind
@Unfiltered_ind 2 года назад
Sir what is r1c1 style and a1stayle.
@Innozant
@Innozant 2 года назад
Start your learning journey from playlist Basic excel..ye basic ke topic hain
@RohitKumar-uy7cx
@RohitKumar-uy7cx 3 года назад
Sir ek detail vedio excel wild card par bhi bnaiye indirect complete krne ke bad
@Innozant
@Innozant 3 года назад
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
@RohitKumar-uy7cx 3 года назад
@@Innozant thank you sir ji 🙏🙏🙏🙏 sir usme saare wild card ka kya kya practical use kr skte hai ye bhi details me bta dijiyega
@Viishhal.
@Viishhal. 3 года назад
Sir, how could I automate cells.If my data is in tabular format
@Innozant
@Innozant 3 года назад
Using function ? And how you want to populate the data...@innozantofficial telegram id
@Viishhal.
@Viishhal. 3 года назад
@@Innozant sure sir
@Healthy-Wealthy43
@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
@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
@shwetkumar1719
@shwetkumar1719 3 года назад
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
@Innozant 3 года назад
Nahi galat hai...sheet ka ref bhi denge exclamation ❗ sign ke saath
@kavitakanwar2161
@kavitakanwar2161 Год назад
Sir innozant channel par sql language playlist hai kia
@Innozant
@Innozant Год назад
Abhi nahi hai dear
@kavitakanwar2161
@kavitakanwar2161 Год назад
@@Innozant ok sir
@shwetkumar1719
@shwetkumar1719 3 года назад
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
@Innozant 3 года назад
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
@shwetkumar1719 3 года назад
@@Innozant ji sir islia maine Arti se Arti kumari kia fir =sum(indirect ("'"&c33&"'!e3:k3")) lagaya fir v nhi aaya
@Harish.Prasad.Semwal
@Harish.Prasad.Semwal 4 месяца назад
7:40 9:12 or (10:32) 11:39 or (12:15)
@SunainaAdhya
@SunainaAdhya 4 месяца назад
All functions are volatile.
@ajaykumar-hu3py
@ajaykumar-hu3py 3 года назад
shaw 1 to 17 interview series
@Innozant
@Innozant 3 года назад
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 😅
@shwetkumar1719
@shwetkumar1719 3 года назад
Sir reference or value me anter kya hai?
@Innozant
@Innozant 3 года назад
Value constant and reference cell address..
@horrorlovestories
@horrorlovestories 3 года назад
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
@Innozant 3 года назад
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
@horrorlovestories 3 года назад
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.
@anilkumarparmar1784
@anilkumarparmar1784 Год назад
Indirect me referance के तौर पे value le sakte hai ya nahi?
@Innozant
@Innozant Год назад
Reference as a text
@anilkumarparmar1784
@anilkumarparmar1784 Год назад
@@Innozant kya value k base pe nahi ho sakta??
@ravi.mahour
@ravi.mahour 3 года назад
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
@Innozant 3 года назад
Very True...🙏😊❤️Bht baariki se samjha hai aapne concept ko..Love it🙏❤️
@ravi.mahour
@ravi.mahour 3 года назад
@@Innozant Thank You Sir 😊😊
@PopatMomu
@PopatMomu 3 года назад
Ye topic 2018 me hota to maja aa jata
@Innozant
@Innozant 3 года назад
❤️🙏😊
@shwetkumar1719
@shwetkumar1719 3 года назад
Sir indirect("b19") & indirect(b23) inme difference kya hai?
@Innozant
@Innozant 3 года назад
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
@shwetkumar1719 3 года назад
@@Innozant yes sir thank you🙏
@yasirkhan4729
@yasirkhan4729 2 года назад
How to use the Exact formula with indirect?
@Innozant
@Innozant 2 года назад
Will add examples in upcoming videos
@yasirkhan4729
@yasirkhan4729 2 года назад
@@Innozant Thanks
@shreyansbaid4384
@shreyansbaid4384 3 года назад
Mujhe ref error dikha Raha hai @innozant
@Innozant
@Innozant 3 года назад
kyu?ref nhi aayega
@shreyansbaid4384
@shreyansbaid4384 3 года назад
=indirect (a1&"!"&a1) isme indirect reference
@shreyansbaid4384
@shreyansbaid4384 3 года назад
=indirect (a1&"!"&"a1") isme Sahi dikha Raha hai @innozant
@shreyansbaid4384
@shreyansbaid4384 3 года назад
Sir plz kya mistake hai Sahi Kar do
@shwetkumar1719
@shwetkumar1719 3 года назад
=SUM(INDIRECT(C33&"!C34:C35")) Sir esko ess tarah sum q nhi a raha
@Innozant
@Innozant 3 года назад
Sahi to hai..kya issue?
@shwetkumar1719
@shwetkumar1719 3 года назад
@@Innozant sir fir v issue a rha
@RohitKumar-wt8qy
@RohitKumar-wt8qy 3 года назад
Sir indirect to bahut confused kar raha hai
@Innozant
@Innozant 3 года назад
Kyu Rohit..Ye to bht hi pyara function gai..complete tutorial indirect ke pehle finish kijiye..m sure aayega samajh..bht achese
@sethushankaranmadhavanmadh6712
@sethushankaranmadhavanmadh6712 2 года назад
Indirect not good
@Innozant
@Innozant 2 года назад
Why so...it's awesome finction if you are using with another function
@mr.knight7146
@mr.knight7146 Год назад
Poor explanation.
@hemantgusain1260
@hemantgusain1260 3 года назад
Thanks you sir
@Innozant
@Innozant 3 года назад
Thanks Hemant Ji🙏❤️