Vlookup With Indirect And Match Function | Vlookup with multiple sheets | vlookup+indirect+match

[@pramodsingh2887]

Absolutely great fomula sir...👍

[@shivameducationworld]

Thank U

[@pramodchandelpkc]

Very Interesting Formula . Thanks for sharing

[@shivameducationworld]

Most Welcome

[@hemendrakumarvarshney8825]

Superb...

[@shivameducationworld]

Thank U

[@varaprasadme9674]

thank you so much .. your knowledge helped me a lot

[@shivameducationworld]

Most Welcome

[@tarungiri3577]

Bahut hi shandar videos h sir aapke 👌👌👌👍👍👍

[@shivameducationworld]

Thank U

[@salikhashmi8820]

Great video thank you so much for your efforts @shivam bhai❤

[@shivameducationworld]

Welcome

[@अपनीढपलीअपनाराग]

वाह सर, बहुत कमाल की ट्रिक बताया आपने।

[@shivameducationworld]

Thank U

[@sushantkumar907]

Very good trick❤❤❤

[@shivameducationworld]

Thank U

[@AnkitSingh-ir1jp]

Maja aa gya sir supper

[@shivameducationworld]

Thank U

[@mohammadilyas2240]

Excellent زبردست U R great

[@Kingpotash]

I have naver seen such vlookup. It's amazing. Lovely. I will learn more from your videos. Thank you. Kolkata.

[@shivameducationworld]

Thank U

[@kumarvinod6039]

Nice video and good logic

[@shivameducationworld]

Thank U

[@mrvipanjum]

Superb Video me yahi search kar Raha that 👍

[@SyedMuzammilMahasanShahi]

That's amazing. Thanks for the share.

[@shivameducationworld]

Most Welcome

[@amandeepsinghbassi1600]

thanks shivam sir,,you are a great TEACHER

[@jaiyadav1256]

Very good example with good explanation great job

[@excelgurusikander4929]

Informative video

[@shivameducationworld]

Thank u

[@mdtousif7540]

Very helpfull 🥰🥰🥰

[@shivameducationworld]

Thank U

[@skmusicalgroupghinoi8950]

Gajab sir

[@shivameducationworld]

Thank U

[@hiteshchourey9730]

I like this video and new learning skill

[@RiponSarkar21]

Fantastic video. keep it up dear.

[@nasertmv1454]

Wonderful. I like your way of explanation

[@shivameducationworld]

Thank U

[@kpdave1007]

Very good approach to proceed step by step

[@bishanjppharma]

great boss

[@shivameducationworld]

Thank U

[@hrahi3600]

v good vedio

[@shivameducationworld]

Thank u

[@jivanjotiyoutubechannel5338]

Excellent

[@shivameducationworld]

Thank u

[@tahirrizwan1699]

Hi Shivam, I must admit, I have yet to come across such meticulous instructions on any KZbin channel. Your content is highly appreciated, all of your contents are very helpful and reduce time to get assignments done.

[@shivameducationworld]

Thank U So Much

[@manmohandeol4908]

Very nice good job Dear👍👍👍

[@abrarbd2004]

Excellent, learnt a lot. Love from Bangladesh

[@sandeepgupta6526]

Thanks

[@ravichauhan3933]

very nice

[@shivameducationworld]

Thank u

[@rahulprasad9198]

Sir, No one like in the youtube that provides Content .

[@shivameducationworld]

Thank u

[@sandeepgupta6526]

When I am copy formula from another cell disable exist formula in current cell why? Then I am copy in word and paste in that cell works properly. Please tell me the solution of above problem.

[@afrinsir7479]

Amazing explanation

[@nadeemsaifi1885]

Without selecting different sheets data coming correct how does it work ?

[@ShivamSingh-uj8ld]

I like the formula

[@premabhal3660]

Fabulous!

[@v6586]

Sir aaka formula bahot badhiya hai, lekin thoda zoom karake dikhao taki samjhane me asani ho

[@shivameducationworld]

👍

[@dtoxicative]

You are a genius Brother Shivam. I have never seen such thorough instructions in any channel on KZbin..... Love From Pakistan Edit: You have earned a Sub and respect brother. Stay Blessed

[@sunilkumargautam8971]

Ggggggggggggggggggggggggggggggggg 😮 good 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍 ggf n😊

[@abhisheksrivastava-sh6pp]

Thank you sir

[@arunkumardhiman2871]

Sir agar colam disarenge k sath 1saman bhi na ho toh kese krange

[@jaiyadav1256]

Superb

[@arunkumardhiman2871]

Or sir agar colam disarenge k sath kam ya jyada ho toh tab kaese kare

[@hiteshchourey9730]

Sirji, excel 2007 mai apka formula support nahi Kar raha hai. Ek sheet par data fetch karta hai baki sheet par fecth nahi hoo raha hai. Apko thanks.

[@hiteshchourey9730]

Sirji, excel mai macro on pivot table ka video banaye.

[@arunkumardhiman2871]

Sir agar colam same no ho toh tab kay karenge

[@v6586]

Sir thoda zoom karake dikhao taki formula samajhme aaye

[@sanjayveladi1154]

Dear Sir, how to use this function with other workbook

[@soumensaha4426]

Thank u. I have tried to download the file for practice but unable to download it. It only show the data.

[@sumanrakshit5342]

Give me a video link on How to look up value and extract form sheets of a excel book by only using Sheet Name only ,

[@shivamdixit381]

I need one help. I have one sheet in which data comes from another sheet. In this new sheet there are some data blank in 1 row (suppose row 'X"). I want only filled data from that "X" row with all other rows & column to another sheet automatically. How can it be done??

[@sumanjain1224]

How vlookup with multiple files for multiple sheets

[@TEJGADGETS]

Indirect function multiple workbook Mai use karte hai toh error ata hai please help me

[@ranjeetprajapat1386]

मै आपसे excle मे सॉफ्टवेयर बनाना सीखना चाहता हु क्या आप मुझे ऑनलाइन सीखा सकते है

[@atherrana4557]

SIR I NEED YOUR HELP IN MY SHEET VLOOKUP FORMULA IS GOING WELL BUT WHEN I ADDED INDIRECT FORMULA IT SHOWS REF EROOR

[@sureshm7782]

There should be no space in sheets name e.g., "Sheet 1" or "My Sheet" or "Week One" it should be Sheet1 or MySheet or Week_One without space. Hope this helps, if you have not got the solution yet.

[@riseofkingdoms8816]

Bro ek video mery ley bano jis ma master sheet ma tamam school ka nominal roll ho ho aur us ma intri kary aur wo class wise apni apni sheet ma Jaye

[@kmvit2007]

Hello Brother, my lookup value needs to do a reverse lookup in my lookup table.. meaning the value i need is to the left of my lookup value... how do I modify my formula using your method ? I have data in 1000+ sheets

[@arvindvishwakarma706]

Sir apki file dijiye practice ke liye please sir please

[@rustamkhan1386]

very nice video, how to we split master sheet data into multiple sheets using vlookup with match formula not repeat data table previous entry already exist in sheet

[@sachinseli03]

can you share the data sheet!!

[@ubaidillahmuhammad20]

nice, may i have the file Sir?

[@manjit.sarania]

Very healthful trick but you didn't zoom the screen and isn't clear visible

[@shivameducationworld]

You can check this video for clear explanation kzbin.info/www/bejne/eGS8kIZqa9uDd5o

[@MuhammadPashia]

After X lookup V look is not in use that much. Appreciate if you please share comprehensive videos on X lookup which is prevalent nowadays. I have gone through your videos list and there is hardly any video on x lookup. Now there is no need for Index match and some other functions in the presence of X lookup. Appreciate your valuable comments please!

[@sunilsharmacricketgyan]

Hi Sir Please share the Practice sheet

[@shivameducationworld]

please check description box it is right there

[@sunilsharmacricketgyan]

@@shivameducationworld thank you sir got it.

[@shivameducationworld]

@@sunilsharmacricketgyan Most Welcome

[@Excelking511]

in your video you put VLOOKUP on unique values in master data file ie Challan no its mean that you have copy past that data from another sheet .lets Suppose that we have 50 sheets its possible to copy past in right manner .we can use VLOOKUP formula on unique values only & Master file also be open in blank sheet so without copy past with unique values we can't use vlook up & however , we have create unique values and pasted in Master file as, same unique values should be there in entire sheet also. So pls provide solution for same . Jai hind .

[@ibadkhan9024]

Sir its not working 😢

[@aweshmemon5453]

Samjha nahi paa rahe ho

[@hasnainchangi3457]

Superb

[@shivameducationworld]

Thank U

[@samrathshah8429]

Superb

[@shivameducationworld]

Thank U