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😇

[@omkarkelshikar7484]

Sir your genius and great job 😊

[@shrikantbadge3978]

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

[@Innozant]

Thanks

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

[@virendrahardiya2797]

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

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

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

[@tejpalsain1507]

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

[@Innozant]

Thanks Tejpal Ji🙏❤️👍

[@sandeepaswal8944]

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

[@Innozant]

Thanks Sandeep..Hope you are enjoying Indirect concept

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

[@sreenivasulubathala8996]

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

[@Innozant]

Thanks dear♥️👍

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

[@HarsitSharma-h8m]

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

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

[@manjit.sarania]

Very powerful formula sir

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

[@mdibrahimsheikh1680]

Thanks for explaining in good way....

[@Innozant]

Thanks dear♥️

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

[@superNareshg]

Wow great sir. Thank you.

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

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

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

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

[@kinghundred]

very excellent sir

[@tt_badmash_9560]

Superb sir

[@vickyghosh1664]

Thanks sir for ur videos

[@Innozant]

Thanks dear

[@heeralalkumawat2132]

Sandar

[@hemantgusain1260]

Thanks you sir, really interesting use of indirect.

[@Innozant]

Thanks Hemant for lovely appreciation 👍🙏❤️

[@HarsitSharma-h8m]

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

[@Rejuanhaque]

Excellent sir

[@Innozant]

Thanks Zoie Raem .🙏❤️

[@bhoopendraraghav9781]

Very nice sir g....

[@Innozant]

Thanks Bhoopendra Ji 👍🙏❤️

[@deepakchauhan4974]

this one is really amazing sir

[@Innozant]

Thanks Deepak Ji

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

[@anitasinha7278]

So simple and powerful

[@Innozant]

Thanks Anita 🙏❤️❤️🙏

[@sarangkulkarni5740]

Nice. Thanks

[@Innozant]

Thanks Sarang Ji🙏❤️

[@IGTroy]

Very nice

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

[@rhashmi1]

Beautiful

[@binaykumarnayak9114]

Excellent

[@Innozant]

Thanks Binay🙏♥️

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

[@ghanshyamayodhyaprasadgupt727]

Thank you so much

[@Innozant]

Thanks Ghanshayam

[@shrikantbadge3978]

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

[@dhruvalpatel5316]

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

[@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.🙏❤️👍 kzbin.info/aero/PLmHi7ol7EPSAajekuvYlddxY7TnbBUFYQ

[@aamirmasood4655]

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

[@Innozant]

👍watch step by step till end.

[@m.k_tv]

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

[@Innozant]

👍

[@atulgoodify]

Nice

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

[@tohidahmad1194]

nice guru ji

[@Innozant]

Thanks Tohid Ahmad Sahab🙏❤️👍

[@kevinshukla8730]

Hello sir Indirect+Index match Sikhayye please🙏

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

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks Gaurav Ji🙏❤️

[@krishnananda9466]

U R a Indepth Excel Trainer Brother

[@Innozant]

Thanks Krishna for toir valuable feedback 🙏❤️

[@RohitKumar-uy7cx]

Wow sir ji

[@Innozant]

Thanks Rohit Ji👍🙏❤️

[@RohitKumar-uy7cx]

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

[@RohitKumar-pi5gb]

Sir vlookup+indirect m naming range karna jyada important hai

[@Innozant]

Yes Rohit Ji

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

[@Mohammed_Hanif1]

How to freeze the cell value that D2 converted to $D$2

[@subhasisbhattacharjee9187]

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

[@Innozant]

Yes dear..🙏

[@niteshmandal5816]

Sir mere kahne ka matlab hai bina space bale ho jate hai indirect se jaise ki gold silver basic bale lekin agar ramyond siyram or black berry bale kaise kare discount nikalne ke liye kyuki black berry me to space aa jate hai or naming range bina space hota nhi hai fir kaise honge space bale 🤔 reply sirz

[@msexcelgooglesheet374]

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

[@Innozant]

Yes you can..👍

[@msexcelgooglesheet374]

@@Innozant 🙏✅

[@Altaf_Alam]

😀😀😀❤️

[@ADangergaming]

Sir, where is this practice file please share .

[@Harish.Prasad.Semwal]

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

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

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

[@bikashkumarparida7595]

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

[@ADangergaming]

Sir,naming range kaise banate h

[@Innozant]

Basic excel playlist me naming range ka videos dekhiye

[@ADangergaming]

@@Innozant thankyou sir

[@PradeepKumar-hd1ty]

VBA Series start kijiye sir please

[@Innozant]

Thanks Pradeep Ju❤🙏

[@PavanKumar-cm2sz]

👌👍🙏🙏🥰

[@Innozant]

Thanks Pavan🙏❤️

[@javedahmed2317]

Without name range bana kar bhi kiya ja sakta hai

[@Innozant]

Yes..🙏❤️

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

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

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

[@souvikdas9110]

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

[@shrikantbadge3978]

Thank you

[@shaileshkumar-qf6bd]

Sir 9:30AM ko 9.5 me kaise krte hai

[@sourabhpanchal1105]

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

[@Innozant]

Kya prob face ?

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

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