Excel INDIRECT Function Explained | Step by Step Excel INDIRECT Tutorial in Hindi
ฝัง
- เผยแพร่เมื่อ 6 ต.ค. 2024
- 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
i have been watching your video from last 7 hours
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.🙏❤️
Very informative Sir 👍👍👍
Dude greetings from pakistan. You are the best
Thanks dear
Awesome sir my all the query and doubts of indirect formula to clear from this video very very thanks Guru ji...
What a explanation. I saw many videos but, I could not understand. This is the best video to understand indirect. Thank u bro
Thanks Srinivas
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.
Outstanding teaching style :) Thank you so much !!!
Thanks
Thanks for introduction Indirect function.
अभी मुझे इसका बेसिक यूज़ ही आता है।
Advace indirect का इंतजार रहेगा।
Aaaj concept aapko samjh aaya hoga aisa umeed karta hoon..🙏
@@Innozant हा जरूर।
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.
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.
aa gaye hum firse revision karne. thank you sir amazing explanation.
Thanks dear
Thanks this Video helped lot in performing daily job
❤️
Sir your every video is very helpful for Us 😊
Thank you ❤😊
SIR YOU ARE GOD
Amazing trainer, thanks for explaining it so minutely. In this manner we will not never forget
Thanks Darpan.. Really means a lot to me
Sir bahut acche se samjhaya aapne
The Amazing channel. Amazing Teacher.
Thanks dear
Sirji macro video...
You are too good...
After some time
Thank you sir ji.
Thanks ❤️🙏
Very useful and helpful. Thank you!
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
Hahahaha..very nice
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!!! 🙂
Thanks Pradeep,Learn step by step Indirect Function series.Will try to make you understand this concept and able to use it .
@@Innozant Thank you very much Sir🙂🙂🙂
THANK YOU SIR
Thanku sir thoda thoda samajh ayaa hai lekin jaise jaise aur example hoga tho pura clear ho jayega.good night sir
Haan .phirse dekhna ye first video repeat krke...basic jaroori hai.good night
Nice video sirG thank you so much
So nice Sir ji
Thanks Sanoj🙏❤️
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
Thanks Ankit ji...meri koshish yhi rhta h ki eaay to understand apko kara saken..aage bhi dhyan rakhenge dear
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
Sure will start vba automation afyer power BI series
I made some experiments with basic concepts!! Maza aa gaya!!, Thank you sir
Thanks Vishal Ji🙏❤️
Something new learn in excel
Indirect ❤️🙏👍
🙏👍❤️thanks Good Night
Very valuable Sir, Thankyou So much for this video
Thanks dear..❤️🙏Sukriya Dilse
sir aap Jo padhate aapka charan chhune ka dil kar raha hai
God bless you dear..Keeo learning
thank you Sir, you are best
Thanks sir
Thanks you sir
Thanks Hemant Ji🙏❤️
Good sir indirect ko abb sikha asan hai
Thanks Gaurav Ji🙏❤️
Excellent I love your explanation great keep it up brov
Thanks dear ❤️
Thank you sir
You are amazing
😇
Thanks dear
excellent
Thank you Sir Very Much
Thanks a lot indirect function , offset function kab lavoge
Thanks...Dear jab indirect finish next topic offset
Amazing explanation!
Thanks
Nice details vdeo
Vow it's amazing
♥️👍
Amazing & Excellent
Thank you sir,
Please make video on uses of Symbols in excel formulas
Sure dear
Sir ap cube formula ka lecture BHI u tube par dalay
very excellent sir
Nice❤
Josh alway high guru g ka😊👌🏻
Thanks Puran🙏❤️🙂
Thank you for function
You Anil.. Thanks for Support🙏♥️
Good
Nice sir, thanks
Thanks Shaikh Sahab🙏❤️
Sir am cube formula ka lecture bhi
सर रेंज को हम बिना एम पर्सेंट लगाए कॉलन के साथ नहीं दे सकते क्या
great job done bro
Thanks Ajay Ji🙏❤️GN dear.
i hope you will upload offset part also asap then we can say that vlookup function part finnished.
Offcourse After Indirect will upload Offset part
Why Ampersand used and double quotes for Colon while giving range ?
👍👍👍
Nice vedio sir ji
Thanks Rohit Ji🙏❤️
❤️❤️❤️❤️❤️
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
multiples vlookup advamce excel videoS uplod korun .
Which software you use to record a video.
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
Can anyone tell me how to use an indirect address match together???
Sir Excel array use
Sir ek detail vedio excel wild card par bhi bnaiye indirect complete krne ke bad
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 🙏❤️
@@Innozant thank you sir ji 🙏🙏🙏🙏 sir usme saare wild card ka kya kya practical use kr skte hai ye bhi details me bta dijiyega
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 😊
Can we use indirect + match. Need a video for this.
Already there ..in mos Interview cracker series
Sir i need help with indirect row column criteria which is not available on TH-cam
7:40 9:12 or (10:32)
11:39 or (12:15)
Sir mujhe odd even kaise nikalte h please bta dijiye
Sir what is r1c1 style and a1stayle.
Start your learning journey from playlist Basic excel..ye basic ke topic hain
मुझे vlookup से अगले सेल के उप्पर वाले सेल की वेलु चाहिए कैसे करे कृपिया मार्गदर्शन करे
Awsome ❤️
❤️❤️❤️❤️🙏🙏 Thanks Lokesh ji
Can we use this in different files because it is not working?? Please confirm what we do
Sir indirect ka use kaha pr use krte hai jayda tr ....
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
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
Sir innozant channel par sql language playlist hai kia
Abhi nahi hai dear
@@Innozant ok sir
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
Ecplained in video and your comment too❤️
Sir reference or value me anter kya hai?
Value constant and reference cell address..
Indirect me referance के तौर पे value le sakte hai ya nahi?
Reference as a text
@@Innozant kya value k base pe nahi ho sakta??
All functions are volatile.
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
Nahi galat hai...sheet ka ref bhi denge exclamation ❗ sign ke saath
Sir, how could I automate cells.If my data is in tabular format
Using function ? And how you want to populate the data...@innozantofficial telegram id
@@Innozant sure sir
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"))
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
@@Innozant ji sir islia maine Arti se Arti kumari kia fir =sum(indirect ("'"&c33&"'!e3:k3")) lagaya fir v nhi aaya
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🤴)
Very True...🙏😊❤️Bht baariki se samjha hai aapne concept ko..Love it🙏❤️
@@Innozant Thank You Sir 😊😊
Sir indirect("b19") & indirect(b23) inme difference kya hai?
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
@@Innozant yes sir thank you🙏
How to use the Exact formula with indirect?
Will add examples in upcoming videos
@@Innozant Thanks
shaw 1 to 17 interview series
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 😅
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
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
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.
Ye topic 2018 me hota to maja aa jata
❤️🙏😊
It is Dynamic and Static not Volatile and Involatile
Indirect function is semi volatile
Mujhe ref error dikha Raha hai @innozant
kyu?ref nhi aayega
=indirect (a1&"!"&a1) isme indirect reference
=indirect (a1&"!"&"a1") isme Sahi dikha Raha hai @innozant
Sir plz kya mistake hai Sahi Kar do
=SUM(INDIRECT(C33&"!C34:C35"))
Sir esko ess tarah sum q nhi a raha
Sahi to hai..kya issue?
@@Innozant sir fir v issue a rha
Sir indirect to bahut confused kar raha hai
Kyu Rohit..Ye to bht hi pyara function gai..complete tutorial indirect ke pehle finish kijiye..m sure aayega samajh..bht achese
Indirect not good
Why so...it's awesome finction if you are using with another function
Poor explanation.
Good evening sir
Apna WhatsApp no dijiye sir