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

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

Sir your genius and great job 😊

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

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

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

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

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

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

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

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

Sir your teaching methods is too gud

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

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.

Very powerful formula sir

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

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

Thanks for explaining in good way....

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

Wow great sir. Thank you.

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

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

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.

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

Superb sir

very excellent sir

Thanks sir for ur videos

Sandar

Thanks you sir, really interesting use of indirect.

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

Excellent sir

Very nice sir g....

this one is really amazing sir

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

So simple and powerful

Nice. Thanks

Very nice

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

Beautiful

Excellent

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

Thank you so much

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

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

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

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

Nice

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

nice guru ji

Hello sir Indirect+Index match Sikhayye please🙏

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.

Thnq sir

U R a Indepth Excel Trainer Brother

Wow sir ji

Sir vlookup+indirect m naming range karna jyada important hai

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

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

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

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

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

😀😀😀❤️

Sir, where is this practice file please share .

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

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

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

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

Sir,naming range kaise banate h

VBA Series start kijiye sir please

👌👍🙏🙏🥰

Without name range bana kar bhi kiya ja sakta hai

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

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

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?

Thank you

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

Sir 9:30AM ko 9.5 me kaise krte hai

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

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

Sirji, yes video clear nahi hai please clear kare

Indirect dhokkevaz hai. Don't use it