Vlookup With Indirect And Match Function | Vlookup with multiple sheets | vlookup+indirect+match
HTML-код
- Опубликовано: 17 янв 2021
- Vlookup With Indirect And Match Function | Vlookup with multiple sheets | vlookup+indirect+match
Download Excel Practice File: docs.google.com/spreadsheets/...
Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World.
SUBSCRIBE TO MY CHANNEL 👉 ruclips.net/channel/UC8sTJeRL...
In this video you will learn how to use vlookup function with multiple sheets using Indirect and Match Function. How to develop your own big formula in excel.
100 sheets se data lookup kaise karen
#vlookup
#indirectfunction
#matchfunction
Doston aap video ko pura dekhiyega aur achchi lage to ise like kijiyega share kijiyega, agar aapka koi sawal hai to aap mujhe comment bhi kar sakte hain ,main aapke comment ka reply jaroor doonga.
PLEASE SUPPORT 🙏 ME FRIENDS BY LIKE 👍 AND SHARE aur SUBSCRIBE KARNA NA BHOOLE.(❁´◡`❁)
Thank You so much.
---------------------------------------------------------------------------------
Our some other videos--
PASTE SPECIAL PART 1 👉 • What Is The Use Of Pas...
PASTE SPECIAL PART 2 👉 • How do you PASTE SPECI...
PASTE SPECIAL PART 3 👉 • How do you Skip Blanks...
V LOOK UP 👉 • HOW TO USE VLOOKUP FOR...
DOUBLE VLOOKUP 👉 • DOUBLE VLOOKUP IN EXCE...
ADVANCE V LOOKUP 👉 • ADVANCE VLOOKUP | vloo...
COUNT FORMULA IN HINDI 👉 • COUNT, COUNTA, COUNTBL...
CONCATENATE FORMULA 👉 • CONCATENATE FORMULA an...
EXTRACT ALL DATA OF REPEATED LOOKUP VALUE USING VLOOKUP FORMULA 👉 • EXTRACT ALL DATA OF RE...
MATCH FUNCTION WITH V LOOKUP 👉 • MATCH Function With VL...
INDIRECT FUNCTION WITH SUM FORMULA 👉 • EXCEL INDIRECT FUNCTIO...
FULLY AUTOMATIC ATTENDANCE SHEET WITH SALARY CALCULATION 👉 • HOW TO | CREATE FULLY ...
---------------------------------------------------------
About this channel-
Doston is channel me aapko office me work karne se sambandhit poori jaankari milegi,doston office me kaam karne ke liye ms excel aur ms word bahut jaroori hota hai,students ko bhi ms office ki bahut jaroorat hoti hai,doston is channel me aapko ms excel aur ms word aur computer se judi saari knowledge ke videos free me dekhne ko regular milte rahenge,yadi aap regular saare videos ko dekhenge to aap computer me perfect ho jayenge,doston main aapko ms excel me basic se lekar advance saari jankaari is channel me doonga aur shortcut keys bhi batata chaloonga,doston ye channel aapko office work/data entry me perfect banata hai.Doston MIS REPORT ke liye bhi aapko is channel me saari jankaari mil jayegi.
Doston agar aapko mera channel pasand aata hai to jaroor subscribe kijiyega.
Thank you so much-------
----------------------------------------------------------
tags: vlookup with indirect and match,vlookup with match and indirect
shivam education world,shivameducationworld,vlookup with match,vlookup with indirect,vlookup with match and indirect,vlookup with indirect and match,indirect with vlookup and match,excel vlookup formula with multiple sheets vlookup in excel in hindi,vlookup with multiple sheets in excel,formula,indirect function excel,vlookup function google sheets,lookup multiple data,indirect match vlookup,indirect match vlookup function in excel,excel tutorial
Great video thank you so much for your efforts @shivam bhai❤
Welcome
Absolutely great fomula sir...👍
Thank U
Very Interesting Formula . Thanks for sharing
Most Welcome
Nice video and good logic
Thank U
Bahut hi shandar videos h sir aapke 👌👌👌👍👍👍
Thank U
thank you so much .. your knowledge helped me a lot
Most Welcome
Gajab sir
Thank U
I like this video and new learning skill
Very good example with good explanation great job
Very good approach to proceed step by step
वाह सर, बहुत कमाल की ट्रिक बताया आपने।
Thank U
Superb Video me yahi search kar Raha that 👍
thanks shivam sir,,you are a great TEACHER
Excellent, learnt a lot. Love from Bangladesh
Excellent زبردست U R great
That's amazing. Thanks for the share.
Most Welcome
Fantastic video. keep it up dear.
Very nice good job Dear👍👍👍
Superb...
Thank U
Amazing explanation
Thanks
I have naver seen such vlookup. It's amazing. Lovely. I will learn more from your videos. Thank you. Kolkata.
Thank U
v good vedio
Thank u
Hi Shivam, I must admit, I have yet to come across such meticulous instructions on any RUclips channel. Your content is highly appreciated, all of your contents are very helpful and reduce time to get assignments done.
Thank U So Much
Sir, No one like in the youtube that provides Content .
Thank u
Wonderful. I like your way of explanation
Thank U
Superb
You are a genius Brother Shivam. I have never seen such thorough instructions in any channel on RUclips..... Love From Pakistan
Edit: You have earned a Sub and respect brother. Stay Blessed
Ggggggggggggggggggggggggggggggggg 😮 good 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍 ggf n😊
Informative video
Thank u
Excellent
Thank u
Sir aaka formula bahot badhiya hai, lekin thoda zoom karake dikhao taki samjhane me asani ho
👍
Thank you sir
I like the formula
Fabulous!
Sir thoda zoom karake dikhao taki formula samajhme aaye
Very helpfull
🥰🥰🥰
Thank U
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
Sirji, excel mai macro on pivot table ka video banaye.
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.
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
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??
very nice
Thank u
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
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 ,
Thank u. I have tried to download the file for practice but unable to download it. It only show the data.
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.
Sir agar colam disarenge k sath 1saman bhi na ho toh kese krange
Or sir agar colam disarenge k sath kam ya jyada ho toh tab kaese kare
nice, may i have the file Sir?
Dear Sir, how to use this function with other workbook
SIR I NEED YOUR HELP IN MY SHEET VLOOKUP FORMULA IS GOING WELL BUT WHEN I ADDED INDIRECT FORMULA IT SHOWS REF EROOR
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.
Sir agar colam same no ho toh tab kay karenge
can you share the data sheet!!
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 .
Indirect function multiple workbook Mai use karte hai toh error ata hai please help me
How vlookup with multiple files for multiple sheets
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!
Sir apki file dijiye practice ke liye please sir please
मै आपसे excle मे सॉफ्टवेयर बनाना सीखना चाहता हु क्या आप मुझे ऑनलाइन सीखा सकते है
Very healthful trick but you didn't zoom the screen and isn't clear visible
You can check this video for clear explanation ruclips.net/video/B3Y_S46vPA8/видео.html
Hi Sir Please share the Practice sheet
please check description box it is right there
@@shivameducationworld thank you sir got it.
@@sunilsharmacricketgyan Most Welcome
Sir its not working 😢
Superb
Thank U
Superb
Thank U