Тёмный

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

Abhijeetji Technical 4M
Подписаться 153 тыс.
Просмотров 978 тыс.
50% 1

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.co...
Join Our Course
👇
App Link For Android
👇
play.google.co...
App Link for IOS
👇
apps.apple.com...
(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

Опубликовано:

 

15 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 267   
@ayushshah3738
@ayushshah3738 6 месяцев назад
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 😊
@Harshu9950fitmass
@Harshu9950fitmass День назад
कैसे
@vanshthukral5477
@vanshthukral5477 8 месяцев назад
Thanks for the amazing explanation!
@sushibhati3392
@sushibhati3392 2 года назад
Me aap Ki sari video dekhti Hu 👌💝
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Thnks dear don't forget to share
@muhammadkaleem4676
@muhammadkaleem4676 8 месяцев назад
So what 😅😅
@Krishna-dy5ho
@Krishna-dy5ho Год назад
Hi Abhijeet bhai , Very informative and Helpful video
@SoulhuntxdYT
@SoulhuntxdYT 19 дней назад
Bhai apne ne to system phar diya ❤❤❤
@biltu5188
@biltu5188 Год назад
Bahut bahut dhanyawad...I will always greatful to you
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Wlcm and keep in touch to learn more
@santoshahire6699
@santoshahire6699 9 месяцев назад
Bohot pasand aaya video 👍👍👍👍👍
@GurpreetSingh-oh6tf
@GurpreetSingh-oh6tf Год назад
It's one of the best video I have seen regarding two sheets comparison...great job👌👍👍
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Thnks
@mukeshpandey658
@mukeshpandey658 Год назад
Thank you sir aap bahut achche se samjate ho👌👌👌👌
@aakashsahu1309
@aakashsahu1309 8 месяцев назад
Thanku.... I just resolved my isuue
@ruhirajput-dm7lf
@ruhirajput-dm7lf Год назад
Bahot badhiya sir ji.
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Wlcm keep in touch to learn more
@mohammadjaved7480
@mohammadjaved7480 Год назад
Amazing Content Thats Great
@RushiMan
@RushiMan 2 месяца назад
Thank you for your knowledgeable information it's really saved my day ❤
@vishaldhiman2843
@vishaldhiman2843 Год назад
very helpful video. great
@TravelServices-d1r
@TravelServices-d1r 9 месяцев назад
You made my day bro
@amejee9111
@amejee9111 Год назад
great job bro, u really saved my time
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Thnks and keep in touch and learn more
@SoulhuntxdYT
@SoulhuntxdYT 19 дней назад
Bhai apka ka to system heee​@@AbhijeetjiTechnical4M
@arunkumar-ws1pk
@arunkumar-ws1pk 2 года назад
Today it is saved my 2 hours of working
@Draqonpanoaqpa
@Draqonpanoaqpa 4 месяца назад
Impressive way to teach....way to go buddy...
@shakthimurugesh3684
@shakthimurugesh3684 Год назад
This video helped me, thank you
@arunkumar-ws1pk
@arunkumar-ws1pk 2 года назад
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
@AbhijeetjiTechnical4M 2 года назад
No but will come
@nooransari9564
@nooransari9564 2 месяца назад
Thank you broooo this is best video ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤ thanks
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 месяца назад
Wlcm
@VidhiMasih
@VidhiMasih 2 месяца назад
This is really helpful thanks
@totalhyper72
@totalhyper72 10 месяцев назад
Very honestly shared
@arvin4892
@arvin4892 Год назад
Superb Abhijeet bhai, guys saved this video. its very damn important topic which can be asked in interview.
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Wlcm
@hameedshaffi
@hameedshaffi Год назад
Wants to filter a data can u help
@zarishali5566
@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😊
@akashyewle5710
@akashyewle5710 8 дней назад
thank you sir
@manojsharmaudaipur9920
@manojsharmaudaipur9920 23 дня назад
Excellent bro
@SumitKhullar0203
@SumitKhullar0203 Год назад
Super job 👍
@juhipandey3359
@juhipandey3359 Год назад
Very well explained 👍
@Radhas_shyam
@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
@AbhijeetjiTechnical4M Год назад
Simple apply vlookup where available only 2 columns
@SoulhuntxdYT
@SoulhuntxdYT 19 дней назад
Hmmm nice gaming videos bhi banao😂
@jahanzaibit
@jahanzaibit Год назад
if we want to write something like Done in formula cell if match data found ?
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Then use if condition like if(isnumber(vlookup formula),”Done”))
@momentsofsurprise7526
@momentsofsurprise7526 Год назад
Thank you so much sir❤❤
@Harshu9950fitmass
@Harshu9950fitmass День назад
यह libre office excel मे भी काम करेगा क्या
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M День назад
Yes
@sandeepsingh-gv5ji
@sandeepsingh-gv5ji Год назад
Sir bot achha, koi contact h apka , incase koi confusion ho to
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Follow me on Instagram and dm me for any confusion
@gumnam99
@gumnam99 3 месяца назад
nice information
@babololo1437
@babololo1437 5 месяцев назад
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
@mukeshdewangan3677
@mukeshdewangan3677 Год назад
Sir mere pass 1 data hai jo unarranged hai. Usko kisi format me kaise layenge?
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Example
@mukeshdewangan3677
@mukeshdewangan3677 Год назад
@@AbhijeetjiTechnical4M sir aap apna contact number ya email de sakte hai? Mai aapko excel ka file send karunga.
@AllinOne-ul5hr
@AllinOne-ul5hr 4 месяца назад
Thank you bro ❤
@nileshmaskar7418
@nileshmaskar7418 Год назад
Thank you bro, this is the video I was looking for . Thanks for this information 👌
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Wlcm
@prashantsingh1892
@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
@AbhijeetjiTechnical4M Год назад
Use iferror function like this iferror(Vlookup(b2,sheets2!a$2:g$400,2,0),b2
@ananyabansal632
@ananyabansal632 7 месяцев назад
Google sheets and excel sheets are same ???
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 7 месяцев назад
Yes mostly functions are same
@ananyabansal632
@ananyabansal632 7 месяцев назад
@@AbhijeetjiTechnical4M thankyou so much
@samikshas.salunkhe6630
@samikshas.salunkhe6630 Год назад
Hi Abhijeet, This video is very helpful for us. Could you please tell me that how to compare two workbook in VBA ???
@yadhukrishnan8299
@yadhukrishnan8299 2 года назад
1st comment, spr video sir ji 👍👍👍👍🙏🙏🙏 Sir,same prblm match formula se bhi nikal jayegana ?
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Yes nikal jayega Thnks dear don't forget to share
@yadhukrishnan8299
@yadhukrishnan8299 2 года назад
@@AbhijeetjiTechnical4M sir,ek query dha, macro with multiple sheet kaise hoga ,pls make a video sir
@sushibhati3392
@sushibhati3392 2 года назад
Thank you sir aap bahut achche se samjate ho 😊❤️
@amanpreetsingh2656
@amanpreetsingh2656 Год назад
Sir aisa possible hai. If i edit drop down list cell's spelling. So result cell's automatic update spelling..??
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Samjha nahi mein
@amanpreetsingh2656
@amanpreetsingh2656 Год назад
@@AbhijeetjiTechnical4M Sir data validation mai list select krke and source mai list area dete hai drop down ke liye. Agar source list mai cell ke spelling change kar du. To automatic drop down cell mai bhi update ho jay aisa ho sakta hai..??
@amanpreetsingh2656
@amanpreetsingh2656 Год назад
@@AbhijeetjiTechnical4M Sir data validation mai list select krke and source mai list area dete hai drop down ke liye. Agar source list mai cell ke spelling change kar du. To automatic drop down cell mai bhi update ho jay aisa ho sakta hai..??
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
@@amanpreetsingh2656 yes ho jyga but Maine kabhi kiya nahi
@amanpreetsingh2656
@amanpreetsingh2656 Год назад
@@AbhijeetjiTechnical4M sir muje bar bar source list mai spelling change krna padta hai. Then drop down list mai change krna padta hai. Otherwise calculation mistake ho jati hai. Bar bar change karne mai boht tym consume hota hai and mistake hone ke bhi chance rehte hai. If you can tell me any solution for this, I'll very thankful.
@jayeshnair1526
@jayeshnair1526 Год назад
How can I contact you.. want to clear some doubts
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Message me on Instagram
@masoodanwer762
@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
@AbhijeetjiTechnical4M Год назад
Explain pls
@mohdabdullah2088
@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
@AbhijeetjiTechnical4M Год назад
Using macro and filter you can do it
@balanagaboddupally2122
@balanagaboddupally2122 10 месяцев назад
Thank you🙏
@rahuldixit3755
@rahuldixit3755 4 месяца назад
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
@AbhijeetjiTechnical4M 4 месяца назад
2nf sheet per vlookup apply karo
@sunilpardeshi1949
@sunilpardeshi1949 5 месяцев назад
i am not gettting NA but also not total value and records match sheet 1(604) & sheet 2 (601) what can I do
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 5 месяцев назад
You are doing some mistake watch carefully and apply
@rudraupadhyay1379
@rudraupadhyay1379 10 месяцев назад
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
@AbhijeetjiTechnical4M 10 месяцев назад
Watch carefully you will get your answers
@deepakpandar3020
@deepakpandar3020 10 месяцев назад
Please explain..
@rudraupadhyay1379
@rudraupadhyay1379 10 месяцев назад
​@@AbhijeetjiTechnical4M I have watched multiple times that's why I asked the question..
@Mrsingh-dg4qh
@Mrsingh-dg4qh 9 месяцев назад
Selected table array me wo 1st column ha
@shaikhtasneem475
@shaikhtasneem475 9 месяцев назад
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
@KhanKhan-iu3we
@KhanKhan-iu3we 2 года назад
Excellent always
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Thnks don't forget to share
@manoranjandas7509
@manoranjandas7509 2 года назад
Brother vlookup to koi bhi try karega iske alawa ar koi formula....
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Index With Match u can use
@indianfreefire7627
@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
@AbhijeetjiTechnical4M Год назад
First use vlookup to fetch data in front of each row data then use row difference to highlight
@ManishYadav-pc7gr
@ManishYadav-pc7gr Год назад
Thanks 👍
@mohdhussain8658
@mohdhussain8658 Год назад
Nice bhai
@sudhirupadhyay9414
@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
@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
@dineshchaudhary2918
@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
@AbhijeetjiTechnical4M Год назад
Message me on instagram
@RaviKumar-uy8ss
@RaviKumar-uy8ss 4 месяца назад
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
@AbhijeetjiTechnical4M 4 месяца назад
Use tocol formula 2nd method You can use filter formula
@golmaal935
@golmaal935 2 года назад
Well explained 👍
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Thanks don't forget to share
@mukeshrajput_2321
@mukeshrajput_2321 Год назад
Double candidate ke liye help krdo sir 2 alag alag 0df hai
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Example pls
@mukeshrajput_2321
@mukeshrajput_2321 Год назад
@@AbhijeetjiTechnical4M mere pass 2 alg result pdf hai.. bs ye dekhna hai ki ..ek lista ke candidate dusri me hai ya nhi..
@artfun7907
@artfun7907 2 года назад
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
@AbhijeetjiTechnical4M 2 года назад
Message me on instagram same id
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Use index With match
@yo55513
@yo55513 9 месяцев назад
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
@AbhijeetjiTechnical4M 9 месяцев назад
Download my app from play store and message there App name -abhijeetji technical 4m
@sonalinayak2104
@sonalinayak2104 Год назад
Tq sir 🙏🙏
@babololo1437
@babololo1437 Год назад
Thank you so much 😊🙏🏻
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
You're welcome 😊
@VISHNUBAINSLA5565
@VISHNUBAINSLA5565 Год назад
1st coloum m Jo s. N. And emp. Code likha ye coloum up m nhi ja Rhe ye formula batao sir
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Mein samjh nahi pa raha telegram per mukhe message karo screenshot lekar I will help there
@authorrambhaveshsharan
@authorrambhaveshsharan 2 года назад
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
@AbhijeetjiTechnical4M 2 года назад
Sorting alphabetical both name column data sir then u will find sequence will maintain
@k.d8887
@k.d8887 Год назад
Plzzz tell how to use v lookup for more than one columm
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Vlookup video available on my channel go to advance Excel formula playlist and watch
@parthopratimdas175
@parthopratimdas175 2 года назад
Thank you sir
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Most wlcm dear
@roarravi
@roarravi Год назад
Last year kash mai ye video dekh liya hota to job se hath nahi dhona padhta 😔❤️
@vishalkaushik8001
@vishalkaushik8001 6 месяцев назад
Thanks for
@san9749301010
@san9749301010 8 месяцев назад
Name to name check kar sakte hain ... Sheet 1 ka name se sheet 2 ka name same hai. Kya !
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 8 месяцев назад
Yes but spelling should be same
@san9749301010
@san9749301010 8 месяцев назад
@@AbhijeetjiTechnical4M how ! Vlook formula or other !
@nishantdhengre8569
@nishantdhengre8569 2 года назад
if i want to see that right emp.code is for right employee name ?
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Vlookup only fetch data from ur master file when lookup value available in your master file that means your name is right
@anuj1205
@anuj1205 2 года назад
Thankyou bhai🙏🙏🙏
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Wlcm don't forget to share
@vipankamboj8121
@vipankamboj8121 2 года назад
Hello sir 2 exams ka results aye ha un 2 ma se common student kasa find kara gye
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
Agar data ek sath combined hai conditional formatting mein duplicate value select karke pata kar sakte ho agar data alag alag sheet mein hai to pahle wale result mein vlookup laga lo dusre wale result ke data se
@vipankamboj8121
@vipankamboj8121 2 года назад
Student name, father name, D.O.B , category. Ha both list me same ha
@Its_Nainwal_Shorts
@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
@AbhijeetjiTechnical4M Год назад
Aap boss wale data mein vlookup lagao
@Its_Nainwal_Shorts
@Its_Nainwal_Shorts Год назад
@@AbhijeetjiTechnical4M bhai thanks to so much bhai
@oorja7731
@oorja7731 Год назад
Thanku
@guptaharsh3183
@guptaharsh3183 Год назад
Please Tell what is Coloum index number? in Vlookup.
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Column index number is position of column that means which column value you want fetch against lookup value
@syedattiq582
@syedattiq582 Год назад
Thank you very much, dear brother. May Allah bless you and open your heart for Hidaya. Please read the Holy Quran.
@AstroEyes-92
@AstroEyes-92 5 месяцев назад
sources file link is not working
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 5 месяцев назад
I think delted
@sktv7462
@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
@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
@vikram123456asdf
@vikram123456asdf Год назад
Better make pivot table of both sheet an make vlookup
@jhonsonmd5255
@jhonsonmd5255 2 года назад
Supper bro
@ashoksinhparmar7597
@ashoksinhparmar7597 Месяц назад
How to make penetrations percentage in excel
@universalthinker-ad3076
@universalthinker-ad3076 Год назад
Bhai primary data se Sara copy kar lene se ho geya, waha tow sab thik tha data.
@_Muhammed_Vlogs_
@_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
@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
@AmritMalwa-z6u
@AmritMalwa-z6u Месяц назад
Also use conditional formatting then unique or duplicate value, apko pata lag jayega itna zada krne ki zarurat nai hogi
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Месяц назад
Conditional formatting condition ke base per formatting karta hai Aur lookup formula dusre sheet or workbook se value ko fetch karta hain And formula always will be automation whenever new data come it will work Conditional formatting Aur lookup formula mein Jamin aasman ka fark hai
@medardayuob
@medardayuob 7 месяцев назад
another tutorial you should use english so as we can explore every where
@malikmukhtar3849
@malikmukhtar3849 2 года назад
Agar different names ho sheets mei than kya karege
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 2 года назад
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
@manusaini7405 Год назад
Vlookup formula not working Plz tell me
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
What’s problem
@md.rakibulhasan6862
@md.rakibulhasan6862 Год назад
thanks
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Wlcm
@AnNa-hk5yg
@AnNa-hk5yg Год назад
Amazing
@Ruhi20189
@Ruhi20189 Год назад
If we have to match multiple workbook
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Год назад
Compile all workbook data at one place and apply vlookup otherwise one by one you can apply vlookup
@mdashadaduzzaman5005
@mdashadaduzzaman5005 11 месяцев назад
Yea to 2 sheet kaa formula but 1 sheet may keyce kareingge
@austindean9274
@austindean9274 Месяц назад
App sub sub ka mix ker daytay hain aur student confuse hoo jata hay. Aur phir hum kia practice karayn
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M Месяц назад
I think you have to learn in proper way you are the one person Jise samjhne mein problem aa Rahi so focus on learning
@ibtechnical614
@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
@AbhijeetjiTechnical4M Год назад
Not able to understand message me on instagram
@computerwork111
@computerwork111 2 года назад
GOOD
@zubairitrading2276
@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
@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
@atulpawar6730
@atulpawar6730 4 месяца назад
Column number 1 kaise liya apne?
@AbhijeetjiTechnical4M
@AbhijeetjiTechnical4M 4 месяца назад
Column index number dal kar
Далее
ITZY "GOLD" M/V
03:20
Просмотров 3,4 млн
НЮША РОЖАЕТ?
00:17
Просмотров 1,1 млн
Comparing Two List in Excel using 4 Methods!
11:45
Просмотров 106 тыс.
7 Ways to Use Vlookup in Excel
16:44
Просмотров 2,7 млн
ITZY "GOLD" M/V
03:20
Просмотров 3,4 млн