Excel VLOOKUP with INDIRECT Function in Hindi | Use INDIRECT to Reference sheets within VLOOKUP
Вставка
- Опубліковано 5 вер 2024
- Excel VLOOKUP with INDIRECT Function in Hindi | Use INDIRECT to Reference sheets within VLOOKUP
Excel Lookup Functions Playlist Link - • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#vlookupwithidirectfunction #indirectfunctiontutorial#Innozant #excelinterviewquestions #indirectinterviewquestions
सर यह बात सच है की यदि हंम तालाब या नदी के कीसी एक किनारे पे खडे हो तो दुसरा किनारा हमारी नजरों के सामने ही दिखता है पर यदि समंदर के कीसी ऐक किनारे पे खडे हो तो दुसरा किनारा दिखना तो बहुत दूर हंम आखों से और दिमाग से अंदाजा भी नही लगा सकते की दूसरा किनारा की दूरी कहाँ तक होगी ठीक वैसे ही सर आपके हर ऐक विडियो मे इतनी खूबियाँ होती है की जिसका कोई किनारा अंत ही नही है
Thanks for Teach us 👌👌
Thanks dear ..God bless You . Happy learning
You are the best teacher. Thanks a lot for imparting your precious knowledge 😇🥰. I am grateful to you sir😇
You have taken us to the real depth of Excel sir. thanks
Thanks
Sir your genius and great job 😊
compled lesson side by side and got success. Really my time is passint excellently with your devotion. At the age of 73 I am feeling myself a student of class 12 th.Deeply impressed. Thanks
Wow...Really impressive..Really means a lot to me sir
जै योगमाया काली माँ 🔱🙏
Sir apne jo GOLD ,SILVER, BASIC , wala jo example karaya tha.. Choose or Vlookup k sath.. Usko mene Vlookup or indirect k sath bhii kar diya😍
Good hai
Sir your teaching methods is too gud
Thanks Anita ji for your valuable appreciation. Recommend you to start your learning Journey step by step from Playlist Basic Excel Onwards
The BEST video on Excel. You are great Sir. My life with excel has become very easy. God bless you Sir.
Thanks Sanjit Ji.. Happy Learning ❤️🙏
That's what I have been telling all. The best excel teacher
सर आपने VLOOKUP with INDIRECT Function बहुत ही बेहतरीन तरीके से सिखाया | आपका सिखाया बहुत ही बहेतरीन है | आप बहुत ही अच्छे गुरूजी हो |
Thanks Sandeep..Hope you are enjoying Indirect concept
Sandar
बहुत बढ़िया सर जी।
सच मे बहुत बढ़िया फंक्शन हैं।
Thanks Tejpal Ji🙏❤️👍
Baar Baar dekho, hazar baar dekho, ye dekhne ki chij hai hamara Innozant...
बहुत सुन्दर तरीके से सिखाया है sir
तू आई दिल मे मेरे तो कैसी देरी हो, हो उजाला दिन मे चाहे रात अँधेरी हो नाम तेरा अब माता पहचान मेरी हो कैसे कहु माँ तुमसे तुम जान मेरी हो 🔱🔱🔱
Sir sare function ache hai vlookup ko boost karney ke liye bas practice karne ki jaroort hai.amazing video thanku sir and good night.👌👌🙏🙏🙏
Thanks Satish..Bikul sahi baag Bina Practice ke Kuch nhi..Yaad rhega phir ..tc.gn. 🙏❤️👍 Practice jaroor Jab time mile Karna .
Very powerful formula sir
Dear Sir your explaining the concept makes us easy to understand. Thanks a lot. May God bless you.
Thanks dear♥️👍
Thankyou sirji Mauj dila di aapne please aur videos banate raho aise he , dhanyawad bht bht
Thanks Abhinav Ji.Haan humesha apko seekhate rhenge kuch naya dear🙏❤
2020 ka ek akela kaam jo acha kiya maine vo tha aap k vedio ko Subscribe karna guru g 👌🏻 😊
Ye Word apka mere liye bht mayne rakhta hai Puran ji,Meri humesa koshish hogi ki apke life me value add karta rahoon.🙏❤️
Yes, you were absolutely right Sir, indirect is really powerful although it does same thing when used with Vlookup but I find it easy to apply. Thanks for making excel so so interesting.
Thanks Kavita.God bless you dear❤️
Thanks sir for ur videos
Thanks dear
Superb sir
Thanks for explaining in good way....
Thanks dear♥️
Sir, vlookup with indirect function ke upar kuch tough example lekar video banaiye plz..
Interview cracker series me hain alreaday aur ..Excel maharaj series me bhi aayenge complex level questions
@@Innozant ok thank u sir dil se.
Awsome video sir I've never seen teacher like u 😎 thank u sir
Thanks Uttam For such a wonderful and valuable comment.. Really mean a lot to me.🙏❤️👍
Excellent sir
Thanks Zoie Raem .🙏❤️
Very nice sir g....
Thanks Bhoopendra Ji 👍🙏❤️
It seems so powerful sir,
I used to use if & iferror or index to solve this sort of problems..
It was not that much easier
Thanks Partha..Happy learning
Nice. Thanks
Thanks Sarang Ji🙏❤️
Thanks you sir, really interesting use of indirect.
Thanks Hemant for lovely appreciation 👍🙏❤️
Wow great sir.
Thank you.
Thanks dear
Very nice
Excellent
Thanks Binay🙏♥️
This video really.good ..sir.
I. am always waiting for ur next video.much more learn from ur video.❤️
Thanks Sahil Shahab for this much love and your wonderful comment.. Really mean a lot to me dear.🙏❤️
very excellent sir
this one is really amazing sir
Thanks Deepak Ji
So simple and powerful
Thanks Anita 🙏❤️❤️🙏
nice guru ji
Thanks Tohid Ahmad Sahab🙏❤️👍
Nice
I try to watch your video on daily basis to learn something new as I want to trained myself for data analysis job at the age of 40. Can you also give idea how to also update for SQL, Pythonthon, Power BI. No math 😭 background.
There is No issue if you don't have math background Sharma Ji ..Age is also not an issue as you are applying for Data Analytics and Reporting profile job.
Kindly upadate Power bi and SQL as well for blooming career.
Thank you so much
Thanks Ghanshayam
Wow sir ji
Thanks Rohit Ji👍🙏❤️
@@Innozant sir aap to gajab ka explain krte hai 👏👏👏👏👏👏👏👏👏👏👏
Sir ye jo apne example karaya hai.. Same isi tarah se hum.. Jo apne pehle example karaya tha.. SILVER BASIC GOLD jo apne choose or Vlookup k sath karaya tha.. To kya uss example ko hun isi tarah se kar saktr hai vlookup with indirect k sath
Thnq sir
Thanks Gaurav Ji🙏❤️
Beautiful
Hello sir Indirect+Index match Sikhayye please🙏
00:59 (Two Table only using If)
04:26
U R a Indepth Excel Trainer Brother
Thanks Krishna for toir valuable feedback 🙏❤️
😀😀😀❤️
sir, kisi workbook ka pata hai lekin worksheet & cell ka pata nahi hai workbook me 200 sheets hai, searial no. 18..2.5 ke base par value ko leke aana hai to kaise layege. please reply.
Sir vlookup+indirect m naming range karna jyada important hai
Yes Rohit Ji
Sir, Wildcard * use kr skte hai na
Instead of _sales
👍
Hello sir i want to do some project with this function can you please help me out..?
We can use wild card in question 2 where there are 5 sheet questions.
Yes you can..👍
@@Innozant 🙏✅
Very informative, but I want to ask if lookup value is in different columns of each table then how this will be resolved by using indirect formula
What's prob ?kindly attempt and lets share with me the prob you are facing
Plz make a video sumproduct + indirect multiple sheet and condition ke sath🙏🏻🙏🏻
Ok...sure layenge Maharaj series me
@@Innozant thank you so much 🙏🏻🙏🏻
Very informative, plz adviae by when you are doing a detailed video on Array functions, or is there any video available already??
Dear Aamir..Array & Sumproduct seprate playlist are there .Learn step by step from there.🙏❤️👍
ua-cam.com/play/PLmHi7ol7EPSAajekuvYlddxY7TnbBUFYQ.html
@@Innozant Thanks alot, I am watching these right now,
👍watch step by step till end.
VBA Series start kijiye sir please
Thanks Pradeep Ju❤🙏
Sir,naming range kaise banate h
Basic excel playlist me naming range ka videos dekhiye
@@Innozant thankyou sir
do you have any course for VBA programing? if yes then I would like to have it
Yes..Live class and video course both options are available
You may visit innozant website for more information
Sir ky is k liye formula ban skta indirect vlookup k sth workbook se data pull kr k laa skta bina file open kiye ???
Haan kr skte h
@@Innozant sir please vedio bnaaiye ispar kuki mera office ka project ki mujhe candidates ki detail extract krni hai unki file se bina open kiya
Sir, where is this practice file please share .
Without name range bana kar bhi kiya ja sakta hai
Yes..🙏❤️
In the 1st example, can we use wildcard * instead of _Sales.
Yes dear..🙏
Sir if possible then plz make a video on xml
Role of xml and important of xml file
No issur dear will make videoS on Xml
Sir aap ne 2:14 video me formula ko freeze kiya hai kesie kiya sir please batayie
equal = ke Bahar space use kren usse formula inactive
Sir Yahi formula hum laga rhe hai to nhi lag rha hai #REF ka error bata rha hai kha galti ho rhi hai smjh nhi aa rha hai pls help?
Please reply what to do?
Sir last question me mera #ref! Error aarhaa h
Jbki maine bilkul same kia h ap k jaise and naming range b sahi di h
Na galat kar re h ..Ref tbhi aayega jab wrong ref pass kr re g phir se dekhiye aur btaiye mujhe
@@Innozant acha okay sir ..m try krunga again
Then I'll let u know
@@Innozant sir hogyaa ..vo naming range lete time table me values add ni horhi thi but ab hogyaa..thanku
Sir kuchh aisa trika bataye ki ham kisi bade data par Kam Kar sake or chahe free m hi karna pade or Ghar bhaithe experience hasil Kar sake or dusri baat m bhi test dekar aata hu uska experience or questions app Tak pahuchana chahta hu ,pls reply jarur karna sir
Achi baat hai.. Dear data Chota ya bada se fark bus itna hota hai ki large amount of data ke Saath kaam krne se apko data pull krne ke liye dhyan deke krna hota hai kaam.. concept to ek hi lgega..Haan share Kar skte Hain Questions..aur students ko help krega.🙏❤️
@@Innozant kaise share karu?
Thank you
👌👍🙏🙏🥰
Thanks Pavan🙏❤️
Sir 9:30AM ko 9.5 me kaise krte hai
I don't why but this trick is not working in my excel 07 version..😅
Apka video dekta hun but formula ko clear nhi dikhay deta, zoom kr ke video daliye
Pehle ke videos me isse the zoom ka .ab ke videos quality bht improve ho chuki hai..laptop se kiya kriye practice
Sir nhi aa rha h value pura correct formula lagne ke baad bhi
Kya prob face ?
Sirji, yes video clear nahi hai please clear kare
Koi issue nahi hai video me dear..may be network issue rha hoga
Indirect dhokkevaz hai. Don't use it
Kab diya apko dhokha ...maine pehle hi bataya hai ki it is a semi volatile function..Use it with caution .
Apply sahi se nhi krenge to phir galti indirect ki to nahi hai🙂🙂
=VLOOKUP($D$2,INDIRECT($D3&"_Sales"),2,FALSE) I DID THIS THIS TYPE ABOVE EXAMPLES