Match Two Excel Workbook | Match Data in Two Excel Sheets | Match Data in Excel

Match Two Excel Workbook | Match Data in Two Excel Sheet | Match Data in Excel
About Video
Namaskar Dosto aaj aap is video mein sikhne jara rahe agar aapke pas two excel sheets hai but data match nahi kar rahe hain to aap kaise two excel sheets ke data ko match karayenge or two alag alag workbooks ke data ko kaise match kareyenge is video mein aapko kaafi details se samjhaya gaya hai
aur aapko match data in excel ye wali video kaafi pasend aane wali hai
Practice File
docs.google.com/spreadsheets/...
Join Our Course
👇
App Link For Android
👇
play.google.com/store/apps/de...
App Link for IOS
👇
apps.apple.com/in/app/classpl...
(USE ORG CODE-LMECH)
Question & Queries
Match Data
match Data in excel
Match data in two excel sheets
match data in two column excel
Match data from one spreadsheet to another excel
match data in excel using vlookup
match data using vlookup
match data in excel using vlookup
match data using vlookup
match data in 2 columns
match data sets in excel
match data from 2 spreadsheets
match data from two excel spreadsheets
Follow me
👇
Instagram id:- / abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Advance Excel Formulas
👇
Vlookup Formula Part 1
• Part-1 | Excel Vlookup...
Vlookup formula part 2
• Part 2 | Excel Vlookup...
Subtotal Formula
• Subtotal Formula | इसे...
Countifs Formula
• Excel Countifs Formula...
Aggregate Formula
• Excel Aggregate Formul...
Sumproduct Formula
• Excel Sumproduct Formu...
Sumifs Formula
• Sumifs Formula With Mu...
Pivot Table Basic To Advance
👇
• Pivot Table
All the images & back ground music use in this video only for education purpose and all credit goes to owner
Disclaimer:--
Note: Copyright Disclaimer Under Section 107 of the Copyright Act 1976 allowance is made for "fair use" for purposes such as criticism comment news reporting teaching scholar ship and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use....
Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai
#matchtwoworkbooksinexcel
#matchdatainexcel
#abhijeetjitechnical4m

[@Draqonpanoaqpa]

Impressive way to teach....way to go buddy...

[@vanshthukral5477]

Thanks for the amazing explanation!

[@Krishna-dy5ho]

Hi Abhijeet bhai , Very informative and Helpful video

[@GurpreetSingh-oh6tf]

It's one of the best video I have seen regarding two sheets comparison...great job👌👍👍

[@AbhijeetjiTechnical4M]

Thnks

[@mukeshpandey658]

Thank you sir aap bahut achche se samjate ho👌👌👌👌

[@nileshmaskar7418]

Thank you bro, this is the video I was looking for . Thanks for this information 👌

[@AbhijeetjiTechnical4M]

Wlcm

[@vishaldhiman2843]

very helpful video. great

[@biltu5188]

Bahut bahut dhanyawad...I will always greatful to you

[@AbhijeetjiTechnical4M]

Wlcm and keep in touch to learn more

[@arvin4892]

Superb Abhijeet bhai, guys saved this video. its very damn important topic which can be asked in interview.

[@AbhijeetjiTechnical4M]

Wlcm

[@hameedshaffi]

Wants to filter a data can u help

[@zarishali5566]

I have an excel workbook which contains 400 sheets. Every sheet has required data in A1 to A10 cells... Is it possible to extract A1 to A10 data of all sheets in a single column of a master sheet? So that A single list is formed which contains all data of all 400 sheets😊

[@juhipandey3359]

Very well explained 👍

[@mohammadjaved7480]

Amazing Content Thats Great

[@arunkumar-ws1pk]

Today it is saved my 2 hours of working

[@santoshahire6699]

Bohot pasand aaya video 👍👍👍👍👍

[@shakthimurugesh3684]

This video helped me, thank you

[@amejee9111]

great job bro, u really saved my time

[@AbhijeetjiTechnical4M]

Thnks and keep in touch and learn more

[@sushibhati3392]

Thank you sir aap bahut achche se samjate ho 😊❤️

[@samikshas.salunkhe6630]

Hi Abhijeet, This video is very helpful for us. Could you please tell me that how to compare two workbook in VBA ???

[@user-sb1cc8fo4o]

You made my day bro

[@aakashsahu1309]

Thanku.... I just resolved my isuue

[@AllinOne-ul5hr]

Thank you bro ❤

[@momentsofsurprise7526]

Thank you so much sir❤❤

[@sushibhati3392]

Me aap Ki sari video dekhti Hu 👌💝

[@AbhijeetjiTechnical4M]

Thnks dear don't forget to share

[@muhammadkaleem4676]

So what 😅😅

[@golmaal935]

Well explained 👍

[@AbhijeetjiTechnical4M]

Thanks don't forget to share

[@ruhirajput-dm7lf]

Bahot badhiya sir ji.

[@AbhijeetjiTechnical4M]

Wlcm keep in touch to learn more

[@ayushshah3738]

The one more method is to use filter in any tsble and data is ctrl+shift+l if we use this shortcut so our work will be done fast 😊

[@nidohadi]

Very honestly shared

[@SumitKhullar0203]

Super job 👍

[@babololo1437]

I needed help. And I contact Sir. He responded right away and helped me so professionally and effectively. I am also moving forward with joining his online classes. He saved me for whole week. Thanks

[@babololo1437]

Thank you so much 😊🙏🏻

[@AbhijeetjiTechnical4M]

You're welcome 😊

[@KhanKhan-iu3we]

Excellent always

[@AbhijeetjiTechnical4M]

Thnks don't forget to share

[@amitroy180]

Thank you sir

[@balanagaboddupally2122]

Thank you🙏

[@arunkumar-ws1pk]

Aapki pivot table bali playlist se mene bhut imporove kiya h...is there more vidoes about pivot table ...pls share if any...wonderful playlist

[@AbhijeetjiTechnical4M]

No but will come

[@vishalkaushik8001]

Thanks for

[@ManishYadav-pc7gr]

Thanks 👍

[@mishraram893]

Woow 🥰

[@jhonsonmd5255]

Supper bro

[@anuj1205]

Thankyou bhai🙏🙏🙏

[@AbhijeetjiTechnical4M]

Wlcm don't forget to share

[@sonalinayak2104]

Tq sir 🙏🙏

[@mohdhussain8658]

Nice bhai

[@oorja7731]

Thanku

[@yadhukrishnan8299]

1st comment, spr video sir ji 👍👍👍👍🙏🙏🙏 Sir,same prblm match formula se bhi nikal jayegana ?

[@AbhijeetjiTechnical4M]

Yes nikal jayega Thnks dear don't forget to share

[@yadhukrishnan8299]

@@AbhijeetjiTechnical4M sir,ek query dha, macro with multiple sheet kaise hoga ,pls make a video sir

[@jooni4]

🎉🎉

[@AnNa-hk5yg]

Amazing

[@amanpreetsingh2656]

Sir aisa possible hai. If i edit drop down list cell's spelling. So result cell's automatic update spelling..??

[@RavindraSharma-jz6pv]

Bhai date ko sequence me kese kare

[@computerwork111]

GOOD

[@sudhirupadhyay9414]

Brother, I want to know that if one sheet has 30 employee codes and the other sheet has 50 employee codes, then how will we match 30 with 50?

[@AbhijeetjiTechnical4M]

Apply vlookup in 50 sheets data , you will seen some result will come with na error that means those values not available in sheets 1

[@Ruhi20189]

If we have to match multiple workbook

[@AbhijeetjiTechnical4M]

Compile all workbook data at one place and apply vlookup otherwise one by one you can apply vlookup

[@AbhishekMishra-uk8ck]

🎉🎉❤❤

[@md.rakibulhasan6862]

thanks

[@AbhijeetjiTechnical4M]

Wlcm

[@Radhas_shyam]

Hi bro, I have 2 sheets , in one sheet I have 3 columns and in sec sheet I have 2 columns, so here if the 1 and 2 column data are same , then the data from 3rd column, sheet 1 should be pulled to sheet 2 column 3, how to do that

[@AbhijeetjiTechnical4M]

Simple apply vlookup where available only 2 columns

[@universalthinker-ad3076]

Bhai primary data se Sara copy kar lene se ho geya, waha tow sab thik tha data.

[@roarravi]

Last year kash mai ye video dekh liya hota to job se hath nahi dhona padhta 😔❤️

[@jahanzaibit]

if we want to write something like Done in formula cell if match data found ?

[@AbhijeetjiTechnical4M]

Then use if condition like if(isnumber(vlookup formula),”Done”))

[@artfun7907]

i have two spared sheets one is called stock with price and another is called calculator in a stock sheet there is 3 columns category and sub category and price that shows in calculator sheet in list form i am not able to get a specific price of category and subcategory wise ex fruit is category and apple is sub category and 100 is price in calculator sheet fruit and apple are showing but how can i get the price of it please help me............ looking to hear from you..

[@AbhijeetjiTechnical4M]

Message me on instagram same id

[@AbhijeetjiTechnical4M]

Use index With match

[@vikram123456asdf]

Better make pivot table of both sheet an make vlookup

[@sunilpardeshi1949]

i am not gettting NA but also not total value and records match sheet 1(604) & sheet 2 (601) what can I do

[@AbhijeetjiTechnical4M]

You are doing some mistake watch carefully and apply

[@medardayuob]

another tutorial you should use english so as we can explore every where

[@masoodanwer762]

i want a solution for similar data of two column in such a way that similar data of two coloumn placed automatically in front of second column and mis matched data will placed below this is there any formula for this?

[@AbhijeetjiTechnical4M]

Explain pls

[@nishantdhengre8569]

if i want to see that right emp.code is for right employee name ?

[@AbhijeetjiTechnical4M]

Vlookup only fetch data from ur master file when lookup value available in your master file that means your name is right

[@dineshchaudhary2918]

I need your help.... Mere pass ek master data hai ...... Usmain device name k according two different entries hai .... Only device name comman hai .....mera pass kuch names hai devices k but main chahta hu ek formula lagau ki toh rows mil Jaye mujko device name k according. Suppose 1000 students ka data hai, usmain se student name comman hai bahut se student ka, assume 100 students hai jinka naam comman hai others 100 students se ..... Name k alava baki sabhi value alag hai jaise enrollment no., Class , age. Mujko bas name k according data extract karna or duplicate wallo ko bhi lekar aaana hai ager hai vaha toh

[@AbhijeetjiTechnical4M]

Message me on instagram

[@rahuldixit3755]

sir kya aap mujhe ye bta jaise ye jo do sheet hai aise meri bhi do sheet hai ..lekin frist sheet pr meri code name or qunty three column h same doosari sheet par hai..lekin frist sheet k anusar doosari sheet pr code name qunty nhi wo uper neeche likhe huye hai. ab dono sheet match kaise karaun same code same. name aaye

[@AbhijeetjiTechnical4M]

2nf sheet per vlookup apply karo

[@k.d8887]

Plzzz tell how to use v lookup for more than one columm

[@AbhijeetjiTechnical4M]

Vlookup video available on my channel go to advance Excel formula playlist and watch

[@syedattiq582]

Thank you very much, dear brother. May Allah bless you and open your heart for Hidaya. Please read the Holy Quran.

[@VISHNUBAINSLA5565]

1st coloum m Jo s. N. And emp. Code likha ye coloum up m nhi ja Rhe ye formula batao sir

[@AbhijeetjiTechnical4M]

Mein samjh nahi pa raha telegram per mukhe message karo screenshot lekar I will help there

[@_Muhammed_Vlogs_]

Sir I use to get file on daily basis example if I get 100 Accounts to work mean trw on same file I will get 108 Accounts. How to identify which 8 Accounts were added in that excel. I tried everything like duplicate or advance filter nothing works. Plz guide me.

[@AbhijeetjiTechnical4M]

Use Vlookup formula where your data in large quantities I meant apply vlookup formula in 108 data against 100 data then u can easily find which 8 data not included still u r facing problem text me on instagram

[@RaviKumar-uy8ss]

bro jaisa ki ak line me name h Aakash and wo 2-4 line chodkar fir aa rha h and aise hi chal rha h or bich m sare name b ase mix h to kya hume un sabko aksath kr sakte h? jaise Aakash ki jitni row h wo sari ak sath. plz help

[@AbhijeetjiTechnical4M]

Use tocol formula 2nd method You can use filter formula

[@mdashadaduzzaman5005]

Yea to 2 sheet kaa formula but 1 sheet may keyce kareingge

[@jayeshnair1526]

How can I contact you.. want to clear some doubts

[@AbhijeetjiTechnical4M]

Message me on Instagram

[@sandeepsingh-gv5ji]

Sir bot achha, koi contact h apka , incase koi confusion ho to

[@AbhijeetjiTechnical4M]

Follow me on Instagram and dm me for any confusion

[@prashantsingh1892]

Ek chese btao agr present sheet me mera kuch data match nhi h ot hm vlookup lga rhe h or jo match data nhi h uski jagah NA naa aa k jo available h present sheet me wo aae toh kaise karinge

[@AbhijeetjiTechnical4M]

Use iferror function like this iferror(Vlookup(b2,sheets2!a$2:g$400,2,0),b2

[@zubairitrading2276]

Dear how i creat that master sheet with employ code like when i enter the code in B the the name show up in C row

[@AbhijeetjiTechnical4M]

Simple apply vlookup in column C against column b which is blank rows (where you will type your code) and drag it then you will see when you type code in column b name automatic will come

[@Ruhi20189]

Formula to add multiple workbook value with duplicate name in another sheet

[@AbhijeetjiTechnical4M]

Already video available visit my channel

[@shriyakarayi2236]

How to compare without having any unique values

[@AbhijeetjiTechnical4M]

lots of trick to match your data its totally depend upon your situation

[@nethrasriram7894]

can you made videos in english or Kannada

[@yo55513]

Sir mein sheet 1 mein data select kar raha hu but jab mein sheet 2 mein Ara hu tab wo table array nay sheet ka blank Ara hein plz help sir

[@AbhijeetjiTechnical4M]

Download my app from play store and message there App name -abhijeetji technical 4m

[@MobileBuddie]

Bhaiya Csp Cash Lenden ka Axcel mein Banaiye n

[@AbhijeetjiTechnical4M]

I will try dear

[@botkabalakrushna3560]

Hiii sir

[@AbhijeetjiTechnical4M]

Yes

[@guptaharsh3183]

Please Tell what is Coloum index number? in Vlookup.

[@AbhijeetjiTechnical4M]

Column index number is position of column that means which column value you want fetch against lookup value

[@vaibhavchudasama9680]

1) 8h 30m 2) 3h 45m 3) 6h 50m....plz tell me formula to calculate this time for average.

[@AbhijeetjiTechnical4M]

here is given formula which will you use as per your condition =WRAPROWS(IF(ISNUMBER(SEARCH("m",IF(ISNUMBER(SEARCH("h",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""))),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""),"h","")/24,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)","")))),SUBSTITUTE(IF(ISNUMBER(SEARCH("h",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""))),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""),"h","")/24,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)","")),"m","")/(24*60),IF(ISNUMBER(SEARCH("h",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""))),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""),"h","")/24,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(F10," "),"1)",""),"2)",""),"3)",""))),2)

[@punisherplays9587]

@@AbhijeetjiTechnical4M oh my god

[@punisherplays9587]

Is this really a formula ... Its really... Freaking

[@mohdabdullah2088]

Mere paas 10 sheets me alag alag date me data hai, usko hume singke sheet me kisi specified dates me daalna hai, means jo bhi duusri sheet me data ho, new sheet me sirf wahi data aae jis date ka hum chahte hai... Ye kaese ho paega? For example ; 18 years ka complete daily data hai and humko sirf weekday ka lena hai.. To aese me holiday and Saturday sunday ka data nahi chahye... To ye kaese karege

[@AbhijeetjiTechnical4M]

Using macro and filter you can do it

[@muradplays4802]

Bro please dates k format 3march2020 type k format ko date wise sort kerni ki video ban de please

[@AbhijeetjiTechnical4M]

First u have to split starting numeric number from dates and then sort asendig order It's totally depend what's your requirement

[@indianfreefire7627]

Mere pass do data h pr vo sare upar niche h to agar vo same h to voh highlight ho jaye please bta dijye sir😢😢

[@AbhijeetjiTechnical4M]

First use vlookup to fetch data in front of each row data then use row difference to highlight

[@mukeshdewangan3677]

Sir mere pass 1 data hai jo unarranged hai. Usko kisi format me kaise layenge?

[@AbhijeetjiTechnical4M]

Example

[@mukeshdewangan3677]

@@AbhijeetjiTechnical4M sir aap apna contact number ya email de sakte hai? Mai aapko excel ka file send karunga.

[@ashwinkumar4168]

List me upper niche ho employe id to compare kaise kare

[@AbhijeetjiTechnical4M]

simple apply vlookup to match it if you are facing problem to match message me on instagram id is abhijeetji technical 4m

[@nethrasriram7894]

Make little slow please

[@manoranjandas7509]

Brother vlookup to koi bhi try karega iske alawa ar koi formula....

[@AbhijeetjiTechnical4M]

Index With Match u can use

[@zak1093]

This will throw error if there is repeating values

[@AbhijeetjiTechnical4M]

If value will be repeat then you have to summarize your data first then apply because all the lookup function give first search result, it wouldn’t go down

[@mukeshrajput_2321]

Double candidate ke liye help krdo sir 2 alag alag 0df hai

[@AbhijeetjiTechnical4M]

Example pls

[@mukeshrajput_2321]

@@AbhijeetjiTechnical4M mere pass 2 alg result pdf hai.. bs ye dekhna hai ki ..ek lista ke candidate dusri me hai ya nhi..

[@authorrambhaveshsharan]

Agar ek sheet mai kuch logo ke name hain and kisi dusre column same name hain but same sequence mai nahi hain.. To uske liye kya kiya ja sakta

[@AbhijeetjiTechnical4M]

Sorting alphabetical both name column data sir then u will find sequence will maintain

[@brilew]

so how do you add all of that in one cell?

[@AbhijeetjiTechnical4M]

Use textjoin formula

[@ibtechnical614]

Bhai agar employee ID se alag alag employee ID ek bar me me kaise find karen jaie hamare pass 500 employee ID hai aur mujhe usme se Sr. No. Alag ahi Karni Hai,100 employee ID ke shath find karna ho to ek bar me kaise karen?

[@AbhijeetjiTechnical4M]

Not able to understand message me on instagram

[@ananyabansal632]

Google sheets and excel sheets are same ???

[@AbhijeetjiTechnical4M]

Yes mostly functions are same

[@ananyabansal632]

@@AbhijeetjiTechnical4M thankyou so much

[@rudraupadhyay1379]

I have one doubt. Column index number should be 2 because "Emp code" is in column 2 then how come you typed column index number as 1 and it gave accurate result?

[@AbhijeetjiTechnical4M]

Watch carefully you will get your answers

[@deepakpandar3020]

Please explain..

[@rudraupadhyay1379]

​@@AbhijeetjiTechnical4M I have watched multiple times that's why I asked the question..

[@Mrsingh-dg4qh]

Selected table array me wo 1st column ha

[@shaikhtasneem475]

Jaha se table arry start hota h waha se count Kiya jata h to column. table arry ek hi clum select kiye h to ek hi lege

[@sktv7462]

Sir, suppose Sachin ny India my 56 score kea , srilanka my 79, england my 92 Australia my 50 same sewag and yuraj scores ,,, and hamy find krna hy vlookup k yuraj score in england , and also sachin score in Australia...kindly guid or link of your video

[@AbhijeetjiTechnical4M]

Is condition mein tumhe ek helper column Lena hoga Aur dono ko combined karna hoga dono jagah per Phir use karna hai vlookup If u want to make master in vlookup join our basic to advance excel mastery course in rs 699

[@Its_Nainwal_Shorts]

Abhijeet Bhai mein abhi beginner hun vlookup formula main mere hi question hai mere Boss ne mujhe ek deta Diya aur kahan hai ki Apne wale data se is data ko compare Karo tho main vlookup kha lagaunga Apne wali data mein yah Jo Boss ne data Diya hai uss main pls help

[@AbhijeetjiTechnical4M]

Aap boss wale data mein vlookup lagao

[@Its_Nainwal_Shorts]

@@AbhijeetjiTechnical4M bhai thanks to so much bhai

[@malikmukhtar3849]

Agar different names ho sheets mei than kya karege

[@AbhijeetjiTechnical4M]

Then result will not come before apply vlookup function make sure one common value must be availble in both sheets or Workbook I hope this will help If any query please let me know

[@manusaini7405]

Vlookup formula not working Plz tell me

[@AbhijeetjiTechnical4M]

What’s problem

[@luckmoni]

Excel to download no ho rha