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

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

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

[@shrikantbadge3978]

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

[@Innozant]

Thanks

[@HarsitSharma-h8m]

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

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

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

[@tejpalsain1507]

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

[@Innozant]

Thanks Tejpal Ji🙏❤️👍

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

[@virendrahardiya2797]

बहुत सुन्दर तरीके से सिखाया है 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🙏❤

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

[@sandeepaswal8944]

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

[@Innozant]

Thanks Sandeep..Hope you are enjoying Indirect concept

[@sreenivasulubathala8996]

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

[@Innozant]

Thanks dear♥️👍

[@superNareshg]

Wow great sir.
Thank you.

[@Innozant]

Thanks dear

[@mdibrahimsheikh1680]

Thanks for explaining in good way....

[@Innozant]

Thanks dear♥️

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

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

[@shrikantbadge3978]

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

[@manjit.sarania]

Very powerful formula sir

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

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

[@deepakchauhan4974]

this one is really amazing sir

[@Innozant]

Thanks Deepak Ji

[@hemantgusain1260]

Thanks you sir, really interesting use of indirect.

[@Innozant]

Thanks Hemant for lovely appreciation 👍🙏❤️

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

[@vickyghosh1664]

Thanks sir for ur videos

[@Innozant]

Thanks dear

[@HarsitSharma-h8m]

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

[@kinghundred]

very excellent sir

[@tt_badmash_9560]

Superb sir

[@m.k_tv]

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

[@Innozant]

👍

[@Rejuanhaque]

Excellent sir

[@Innozant]

Thanks Zoie Raem .🙏❤️

[@ADangergaming]

Sir,naming range kaise banate h

[@Innozant]

Basic excel playlist me naming range ka videos dekhiye

[@ADangergaming]

@@Innozant thankyou sir

[@bhoopendraraghav9781]

Very nice sir g....

[@Innozant]

Thanks Bhoopendra Ji 👍🙏❤️

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

[@anitasinha7278]

So simple and powerful

[@Innozant]

Thanks Anita 🙏❤️❤️🙏

[@sarangkulkarni5740]

Nice. Thanks

[@Innozant]

Thanks Sarang Ji🙏❤️

[@heeralalkumawat2132]

Sandar

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

[@ghanshyamayodhyaprasadgupt727]

Thank you so much

[@Innozant]

Thanks Ghanshayam

[@binaykumarnayak9114]

Excellent

[@Innozant]

Thanks Binay🙏♥️

[@ADangergaming]

Sir, where is this practice file please share .

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

[@IGTroy]

Very nice

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

[@rhashmi1]

Beautiful

[@Mohammed_Hanif1]

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

[@dhruvalpatel5316]

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

[@Harish.Prasad.Semwal]

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

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

[@RohitKumar-pi5gb]

Sir vlookup+indirect m naming range karna jyada important hai

[@Innozant]

Yes Rohit Ji

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

[@tohidahmad1194]

nice guru ji

[@Innozant]

Thanks Tohid Ahmad Sahab🙏❤️👍

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

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

[@javedahmed2317]

Without name range bana kar bhi kiya ja sakta hai

[@Innozant]

Yes..🙏❤️

[@atulgoodify]

Nice

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks Gaurav Ji🙏❤️

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

[@msexcelgooglesheet374]

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

[@Innozant]

Yes you can..👍

[@msexcelgooglesheet374]

@@Innozant 🙏✅

[@GhulamMustafa-cj6tk]

2 types of auto heading changes after filter

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

[@RohitKumar-uy7cx]

Wow sir ji

[@Innozant]

Thanks Rohit Ji👍🙏❤️

[@RohitKumar-uy7cx]

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

[@shaileshkumar-qf6bd]

Sir 9:30AM ko 9.5 me kaise krte hai

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

[@krishnananda9466]

U R a Indepth Excel Trainer Brother

[@Innozant]

Thanks Krishna for toir valuable feedback 🙏❤️

[@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.🙏❤️👍
th-cam.com/play/PLmHi7ol7EPSAajekuvYlddxY7TnbBUFYQ.html

[@aamirmasood4655]

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

[@Innozant]

👍watch step by step till end.

[@kevinshukla8730]

Hello sir Indirect+Index match Sikhayye please🙏

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

[@sourabhpanchal1105]

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

[@Innozant]

Kya prob face ?

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

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

[@Altaf_Alam]

😀😀😀❤️

[@PradeepKumar-hd1ty]

VBA Series start kijiye sir please

[@Innozant]

Thanks Pradeep Ju❤🙏

[@PavanKumar-cm2sz]

👌👍🙏🙏🥰

[@Innozant]

Thanks Pavan🙏❤️

[@hiteshchourey9730]

Sirji, yes video clear nahi hai please clear kare

[@Innozant]

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

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

[@shrikantbadge3978]

Thank you

[@bikashkumarparida7595]

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

[@souvikdas9110]

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

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