Excel VLOOKUP with INDIRECT Function in Hindi | Use INDIRECT to Reference sheets within VLOOKUP

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

[@cartoonloversop6019]

सर यह बात सच है की यदि हंम तालाब या नदी के कीसी एक किनारे पे खडे हो तो दुसरा किनारा हमारी नजरों के सामने ही दिखता है पर यदि समंदर के कीसी ऐक किनारे पे खडे हो तो दुसरा किनारा दिखना तो बहुत दूर हंम आखों से और दिमाग से अंदाजा भी नही लगा सकते की दूसरा किनारा की दूरी कहाँ तक होगी ठीक वैसे ही सर आपके हर ऐक विडियो मे इतनी खूबियाँ होती है की जिसका कोई किनारा अंत ही नही है
Thanks for Teach us 👌👌

[@Innozant]

Thanks dear ..God bless You . Happy learning

[@geetusethi9856]

You are the best teacher. Thanks a lot for imparting your precious knowledge 😇🥰. I am grateful to you sir😇

[@shrikantbadge3978]

You have taken us to the real depth of Excel sir. thanks

[@Innozant]

Thanks

[@omkarkelshikar7484]

Sir your genius and great job 😊

[@RajGopalPandit]

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

[@Innozant]

Wow...Really impressive..Really means a lot to me sir

[@user-pj2ez4ik4q]

जै योगमाया काली माँ 🔱🙏

[@AlimKhan-bl5sh]

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😍

[@Innozant]

Good hai

[@anitasinha7278]

Sir your teaching methods is too gud

[@Innozant]

Thanks Anita ji for your valuable appreciation. Recommend you to start your learning Journey step by step from Playlist Basic Excel Onwards

[@sanjitpaul2953]

The BEST video on Excel. You are great Sir. My life with excel has become very easy. God bless you Sir.

[@Innozant]

Thanks Sanjit Ji.. Happy Learning ❤️🙏

[@rajeshtamang4408]

That's what I have been telling all. The best excel teacher

[@sandeepaswal8944]

सर आपने VLOOKUP with INDIRECT Function बहुत ही बेहतरीन तरीके से सिखाया | आपका सिखाया बहुत ही बहेतरीन है | आप बहुत ही अच्छे गुरूजी हो |

[@Innozant]

Thanks Sandeep..Hope you are enjoying Indirect concept

[@heeralalkumawat2132]

Sandar

[@tejpalsain1507]

बहुत बढ़िया सर जी।
सच मे बहुत बढ़िया फंक्शन हैं।

[@Innozant]

Thanks Tejpal Ji🙏❤️👍

[@shrikantbadge3978]

Baar Baar dekho, hazar baar dekho, ye dekhne ki chij hai hamara Innozant...

[@virendrahardiya2797]

बहुत सुन्दर तरीके से सिखाया है sir

[@user-pj2ez4ik4q]

तू आई दिल मे मेरे तो कैसी देरी हो, हो उजाला दिन मे चाहे रात अँधेरी हो नाम तेरा अब माता पहचान मेरी हो कैसे कहु माँ तुमसे तुम जान मेरी हो 🔱🔱🔱

[@satishojha6240]

Sir sare function ache hai vlookup ko boost karney ke liye bas practice karne ki jaroort hai.amazing video thanku sir and good night.👌👌🙏🙏🙏

[@Innozant]

Thanks Satish..Bikul sahi baag Bina Practice ke Kuch nhi..Yaad rhega phir ..tc.gn. 🙏❤️👍 Practice jaroor Jab time mile Karna .

[@manjit.sarania]

Very powerful formula sir

[@sreenivasulubathala8996]

Dear Sir your explaining the concept makes us easy to understand. Thanks a lot. May God bless you.

[@Innozant]

Thanks dear♥️👍

[@abhinavsingh4208]

Thankyou sirji Mauj dila di aapne please aur videos banate raho aise he , dhanyawad bht bht

[@Innozant]

Thanks Abhinav Ji.Haan humesha apko seekhate rhenge kuch naya dear🙏❤

[@puransingh-sx2tk]

2020 ka ek akela kaam jo acha kiya maine vo tha aap k vedio ko Subscribe karna guru g 👌🏻 😊

[@Innozant]

Ye Word apka mere liye bht mayne rakhta hai Puran ji,Meri humesa koshish hogi ki apke life me value add karta rahoon.🙏❤️

[@kavita8390]

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.

[@Innozant]

Thanks Kavita.God bless you dear❤️

[@vickyghosh1664]

Thanks sir for ur videos

[@Innozant]

Thanks dear

[@tt_badmash_9560]

Superb sir

[@mdibrahimsheikh1680]

Thanks for explaining in good way....

[@Innozant]

Thanks dear♥️

[@swagatamkhanra4667]

Sir, vlookup with indirect function ke upar kuch tough example lekar video banaiye plz..

[@Innozant]

Interview cracker series me hain alreaday aur ..Excel maharaj series me bhi aayenge complex level questions

[@swagatamkhanra4667]

@@Innozant ok thank u sir dil se.

[@uttamsharma9598]

Awsome video sir I've never seen teacher like u 😎 thank u sir

[@Innozant]

Thanks Uttam For such a wonderful and valuable comment.. Really mean a lot to me.🙏❤️👍

[@Rejuanhaque]

Excellent sir

[@Innozant]

Thanks Zoie Raem .🙏❤️

[@bhoopendraraghav9781]

Very nice sir g....

[@Innozant]

Thanks Bhoopendra Ji 👍🙏❤️

[@parthahati2284]

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

[@Innozant]

Thanks Partha..Happy learning

[@sarangkulkarni5740]

Nice. Thanks

[@Innozant]

Thanks Sarang Ji🙏❤️

[@hemantgusain1260]

Thanks you sir, really interesting use of indirect.

[@Innozant]

Thanks Hemant for lovely appreciation 👍🙏❤️

[@superNareshg]

Wow great sir.
Thank you.

[@Innozant]

Thanks dear

[@IGTroy]

Very nice

[@binaykumarnayak9114]

Excellent

[@Innozant]

Thanks Binay🙏♥️

[@situsahoo2482]

This video really.good ..sir.
I. am always waiting for ur next video.much more learn from ur video.❤️

[@Innozant]

Thanks Sahil Shahab for this much love and your wonderful comment.. Really mean a lot to me dear.🙏❤️

[@kinghundred]

very excellent sir

[@deepakchauhan4974]

this one is really amazing sir

[@Innozant]

Thanks Deepak Ji

[@anitasinha7278]

So simple and powerful

[@Innozant]

Thanks Anita 🙏❤️❤️🙏

[@tohidahmad1194]

nice guru ji

[@Innozant]

Thanks Tohid Ahmad Sahab🙏❤️👍

[@atulgoodify]

Nice

[@atulgoodify]

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.

[@Innozant]

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.

[@ghanshyamayodhyaprasadgupt727]

Thank you so much

[@Innozant]

Thanks Ghanshayam

[@RohitKumar-uy7cx]

Wow sir ji

[@Innozant]

Thanks Rohit Ji👍🙏❤️

[@RohitKumar-uy7cx]

@@Innozant sir aap to gajab ka explain krte hai 👏👏👏👏👏👏👏👏👏👏👏

[@AlimKhan-bl5sh]

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

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks Gaurav Ji🙏❤️

[@rhashmi1]

Beautiful

[@kevinshukla8730]

Hello sir Indirect+Index match Sikhayye please🙏

[@Harish.Prasad.Semwal]

00:59 (Two Table only using If)
04:26

[@krishnananda9466]

U R a Indepth Excel Trainer Brother

[@Innozant]

Thanks Krishna for toir valuable feedback 🙏❤️

[@Altaf_Alam]

😀😀😀❤️

[@rakeshyadav-mm8tl]

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.

[@RohitKumar-pi5gb]

Sir vlookup+indirect m naming range karna jyada important hai

[@Innozant]

Yes Rohit Ji

[@m.k_tv]

Sir, Wildcard * use kr skte hai na
Instead of _sales

[@Innozant]

👍

[@dhruvalpatel5316]

Hello sir i want to do some project with this function can you please help me out..?

[@msexcelgooglesheet374]

We can use wild card in question 2 where there are 5 sheet questions.

[@Innozant]

Yes you can..👍

[@msexcelgooglesheet374]

@@Innozant 🙏✅

[@muzammilalikhan3411]

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

[@Innozant]

What's prob ?kindly attempt and lets share with me the prob you are facing

[@Dehati_Program]

Plz make a video sumproduct + indirect multiple sheet and condition ke sath🙏🏻🙏🏻

[@Innozant]

Ok...sure layenge Maharaj series me

[@Dehati_Program]

@@Innozant thank you so much 🙏🏻🙏🏻

[@aamirmasood4655]

Very informative, plz adviae by when you are doing a detailed video on Array functions, or is there any video available already??

[@Innozant]

Dear Aamir..Array & Sumproduct seprate playlist are there .Learn step by step from there.🙏❤️👍
ua-cam.com/play/PLmHi7ol7EPSAajekuvYlddxY7TnbBUFYQ.html

[@aamirmasood4655]

@@Innozant Thanks alot, I am watching these right now,

[@Innozant]

👍watch step by step till end.

[@PradeepKumar-hd1ty]

VBA Series start kijiye sir please

[@Innozant]

Thanks Pradeep Ju❤🙏

[@ADangergaming]

Sir,naming range kaise banate h

[@Innozant]

Basic excel playlist me naming range ka videos dekhiye

[@ADangergaming]

@@Innozant thankyou sir

[@bamboo123456able]

do you have any course for VBA programing? if yes then I would like to have it

[@Innozant]

Yes..Live class and video course both options are available

[@Innozant]

You may visit innozant website for more information

[@utkarsh7479]

Sir ky is k liye formula ban skta indirect vlookup k sth workbook se data pull kr k laa skta bina file open kiye ???

[@Innozant]

Haan kr skte h

[@utkarsh7479]

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

[@ADangergaming]

Sir, where is this practice file please share .

[@javedahmed2317]

Without name range bana kar bhi kiya ja sakta hai

[@Innozant]

Yes..🙏❤️

[@subhasisbhattacharjee9187]

In the 1st example, can we use wildcard * instead of _Sales.

[@Innozant]

Yes dear..🙏

[@anitasinha7278]

Sir if possible then plz make a video on xml
Role of xml and important of xml file

[@Innozant]

No issur dear will make videoS on Xml

[@SandeepRawat-zn7ov]

Sir aap ne 2:14 video me formula ko freeze kiya hai kesie kiya sir please batayie

[@Innozant]

equal = ke Bahar space use kren usse formula inactive

[@amazingindiabyshiva8357]

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?

[@arjuntuteja5955]

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

[@Innozant]

Na galat kar re h ..Ref tbhi aayega jab wrong ref pass kr re g phir se dekhiye aur btaiye mujhe

[@arjuntuteja5955]

@@Innozant acha okay sir ..m try krunga again
Then I'll let u know

[@arjuntuteja5955]

@@Innozant sir hogyaa ..vo naming range lete time table me values add ni horhi thi but ab hogyaa..thanku

[@ausafrehman5462]

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

[@Innozant]

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

[@ausafrehman5462]

@@Innozant kaise share karu?

[@shrikantbadge3978]

Thank you

[@PavanKumar-cm2sz]

👌👍🙏🙏🥰

[@Innozant]

Thanks Pavan🙏❤️

[@shaileshkumar-qf6bd]

Sir 9:30AM ko 9.5 me kaise krte hai

[@souvikdas9110]

I don't why but this trick is not working in my excel 07 version..😅

[@pradyutbiswas4977]

Apka video dekta hun but formula ko clear nhi dikhay deta, zoom kr ke video daliye

[@Innozant]

Pehle ke videos me isse the zoom ka .ab ke videos quality bht improve ho chuki hai..laptop se kiya kriye practice

[@sourabhpanchal1105]

Sir nhi aa rha h value pura correct formula lagne ke baad bhi

[@Innozant]

Kya prob face ?

[@hiteshchourey9730]

Sirji, yes video clear nahi hai please clear kare

[@Innozant]

Koi issue nahi hai video me dear..may be network issue rha hoga

[@sethushankaranmadhavanmadh6712]

Indirect dhokkevaz hai. Don't use it

[@Innozant]

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

[@bikashkumarparida7595]

=VLOOKUP($D$2,INDIRECT($D3&"_Sales"),2,FALSE) I DID THIS THIS TYPE ABOVE EXAMPLES