🤓Extract All Data Of Same Repeated Lookup Value 👍 Using Vlookup In Excel || Hindi

Vlookup formula in excel hindi to extract all data for same lookup value every excel user must know.. using countif formula . Vlookup Results from Repeat Values in excel to find the results of the same person with repeat data entries. how to find duplicate information in Excel? Quickly find and delete duplicate data in Excel with this easy function. While there are many ways to find duplicate data this is the fastest and most efficient. #VLookup is an important lookup function at this time. When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of #Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows. #deepakeduworld
Download Training File : drive.google.c...
best video to learn Excel iferror formula in excel
• How to use IFERROR for...
How To Use Name Manager And Define Name in EXCEL | In Hindi
• How To Use Concatenate...
how to use concatenate formula in excel | Hindi | join data of different cells into a single cell
• How To Use Concatenate...
countif formula in excel in hindi
• COUNTIF formula in exc...
VLOOKUP VIDEO SERIES:
1. vlookup in excel with example in Hindi
• Vlookup in Excel With ...
2. How to use vlookup for multiple values || Trick to use vlookup for large data
• सारा Data एक बार में V...
3. Vlookup in multiple sheets in excel || In Hindi
• Vlookup in multiple sh...
4. How To Use Double VLookup in Excel-Nested vlookup
• How To Use Double VLoo...
5. Dynamically Updated Vlookup Formula in Excel
• How To Make a Dynamica...
6. How To Use Vlookup With Multiple Excel Workbooks
• How To Use Vlookup in ...
7. HLOOKUP in excel with example in Hindi
• HLOOKUP in excel with ...
8. vlookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..
• Vlookup Magic 😮 Trick...
9. Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
• Index Formula in Excel...
10. How To Use Vlookup 👉 For Multiple Lookup Values In Excel
• Vlookup in Excel in Hi...
11. How To Create Picture Lookup In Excel 👉 image vlookup लगाना सीखो 😎
• How To Create Picture ...
12. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
• Index + Match Function...
13. Vlookup Powerful 💪 MAGIC TRICK 👉 Marge data from multiple Excel workbooks into one
• COMBINE Multiple Excel...
if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe to Deepak EduWorld ► / deepakeduworld
Tags:
Vlookup formula in excel, excel vlookup functions, deepak eduworld, deepak nehra, excel tutorial, excel tips, computer tips, vlookup multiple criteria, multiple lookup values, vlookup multiple columns, excel user, computer user, vlookup repeated values

[@DeepakEduWorld]

Vlookup Full Tutorial Basic to Advanced kzbin.info/www/bejne/jGW8mISKe7Ggr8U

[@VijaySharma-do8lj]

sir jo recruitment hai plz usi ke bare me btao jo apne link beja hai time period jyda hai or confusion part bhi hai so plz same value ko 2 worksheet me kese find karte hai plz

[@shekharcomputerclass7533]

kzbin.info/www/bejne/Y4iccmyjiLCjfrM

[@gelotylashtash4665]

8200794895 Contact me sir

[@sushantpujhariofficial]

@@gelotylashtash4665 l

[@israrvessal5831]

Hello sir..how are you Sir i am a sales person. I have 6 routs in a week. And visit every each area 48 times in a year. Now i want to get every area sale consolidate in one cell.... Please give guide me..thank you

[@Sarfu1]

Great Sir... You are saving my 1/5 times of my office work... Thank You Sir.

[@smartlearningwithrajeshrai]

दीपक मैंने आज आप का वीडियो देखा । सही मायने में आप गुरु हो। Excel पर आपका कमांड जबरदस्त है।

[@krmotionexcel]

Sir ji........mere khvais puri karhi di aaap ne........ Thanks..........🙏🙏🙏 I love this channel............Yes you're ON..........

[@israelyahudi495]

In Excel 2016 and above version this huge brain works reduced. Select Data and convert as a Table and Directly insert Slicer (Hardly it will take 2 minutes) also it will give you more options to choose another look-up filter (e.i Slicer) Anyways Awesome job. 👍 for those who are not yet reached in Excel 2016

[@vibhujain6615]

This was so helpful man. I wasted time watching other channel videos. This was the most useful. Keep making videos like these, I mean excel.

[@yingkionglab8143]

Thank you sooo much

[@sumitrathod2814]

Thank you thank you thank you...so much sir....!!!! U resolve my problem...!!!!

[@nisharali5616]

Thank you so much sir. You have solved my big problem. I am looking since long time this solution

[@C4CCoachingForCareers]

All Excel Lookup Function: kzbin.info/aero/PLl2uwOt1hHQtb5FzyeJezM3bzZAm2B1qr

[@RahulKumar-lz9gn]

Well, sir I would like to tell you that which you have told me under 17:06 minutes, that the same work I took approximate forty five to fifty minutes. Thank you so much for this concept.👌👌👌👌✌✌

[@bpsingh6503]

Very nice presentation

[@suryamanishakti3369]

Thank you deepak ji mai kai dino se pareshan tha na jane kitni sari vidio dekh dali iske liye but finally aapka video dekha. Very helpful for me. So thank you again.

[@PawanKumar-dz4sy]

Thanks sir it's very useful for me at workplace

[@nlsonpalrly2977]

THANK YOU VERY MUCH DEEPAKJI. THANKS FOR SUCH A VERY EDUCATIVE VIDEO. I AM NOT ONLY A SUBSCRIBER OF YOUR CHANNEL BUT YOUR FAN ALSO AND I HAVE LEARNT EXCEL EASILY FROM YOU. THANKS.

[@rohitchandaliya8874]

Bhai g bhot bhot dhynywaad apka mera sara kaam isi k chkkr me atka pda tha tnks a lot deepak sir

[@amjadmkhan3383]

Duplicate value in vlookup wale comment ka sahi jawab hai . Thanks

[@mdr254]

Thanks you so muchhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh It was my need today..........................From Pakistan Punjab Faisalabad

[@jesusislove2481]

Thank you for very useful vedio

[@shobhaguha2425]

Very informative... thank you for sharing

[@manoharanduraisamy284]

Thanks for sharing 🙏

[@kishorebabuadari2174]

Very very thanks this video helps me alot

[@rajanphadke]

thanks Deepak for Excellent explaination -

[@prasannakumar6130]

Thank you very much for the vedio and good explination with details

[@umeshmishra2010]

bhaut badiya sir

[@somilagrawal7871]

Tanks you so much sir great job 🙏👍

[@2012thakur]

Dear sir it's very helpful tips

[@anshulbharti683]

Ap se bada koi master nahi you tube par

[@GyanOnTube]

want to learn office 2019 and office 365

[@Vizinger]

This was a wonderful explanation - very clear and to the point. Very helpful. God Bless you!

[@atulshukal4072]

Very good Sir Thenks

[@vmarkscreening4106]

Thank u Deepak sir

[@sanjeevkumar-yh6pc]

Thanks sir for this video and also like all video for extra knowledge

[@UndispustedChamp]

This can also be used to bring values from adjacent cells at one place of duplicate items & identify the differences between them. Good demo. 👍🏻

[@Pradeep34281]

Graphic image you title is to the point, and excellent presentation

[@sreenivasulubathala8996]

Dear Deepak very useful.

[@lakshmankumar7832]

sir abhi tak aap jaisa clear video pure KZbin main kahi nahi hai

[@dnyaneshwarshinde2934]

I saw your video on you tube and I taught my computer teacher this trick.

[@GyanOnTube]

lean more office 2019 and office 365 new formulas and new function

[@EdutechSolution]

please visit my channel also. for vlookup kzbin.info/www/bejne/Z5_SeHt5iqyri68 Channel link kzbin.info/door/Yalru61E3cHHeHqHW3cT_Aabout

[@souvikdas9110]

This formula is very useful for Those who doesn't have excel 360

[@sheru67]

Thank you very very very very very much. You have no idea how much this video was helpful for me. After 30+ videos I got a solution to my data management because of this video. Kudos to your knowledge on excel. Simply Hats off. :)

[@debaprasadgorai452]

Apka ye video mera bohot kam me aya..thanks sir..apka ye video ne mera bohot help kiya..mene ye karne ka bohot try kiya tha lekin nahi ho paya..apka ye video dek kar samaj me a geya..thanks..🙏

[@DeepakEduWorld]

😁👍👍👍

[@kishor9867566166]

Nice very good

[@jeetendrak8073]

👌 video Deepak

[@AmanKumar-vk2nv]

Great sir

[@vasubisai7637]

Well explained deepak

[@AmirKhanAnadil]

Kamal ki video hy bhai. Me is video k lye hht search kia par mujhe shayd pta nahi ta kaise search karna hy. Me ne apky invoices wale 3 parts ki video dekhi wahab bhi sawal pocha tha k kahi aisa nahi ho sakta k me invoice no lekho or dosre sheet se us invoice k against sara data mere invoice me ajay or invoice tayar ho jay. Ab ye kam sekh kr mera kam asan ho gia. Me simply apne invoice me invoice ka no dunga or us invoice k tamam product pehli sheet se copy ho jaingay. I mean thanks alot. Ap ne kam bht asan kar dia. Thank u so much

[@DeepakEduWorld]

🤗🤗🤗😊😊😊😊😊

[@DeepakEduWorld]

Keep learning.. keep supporting 🤗

[@richashivhare2049]

Nice thank you so much

[@narottammanihal8463]

Great sir, Kamal kar diya aapne sir मज़ा आ गया सर ।

[@asit5160]

Thank u sir just great idea

[@deepamanmappy]

Amazing sir

[@sazalsarkar2130]

Dada Nomoskar. Just Wow.

[@user-cw7vb8sb6u]

जबरदस्त सरजी. U r great

[@rajenderaggarwal1182]

Really helpful

[@Bilalahmed-lj6yb]

Wonderful explanation keep it up

[@QSOComputer]

Sir boht e Zabrdast banya ha man nay is sy boht benefit b liya ha Thanks 😊 ab agr ap is ka koi or soltion dy den Xlookup kay sath to ziyda best ho ga q kay jab ham 40000 tak entries kar rahy han to sheet hang boht hoti ha so agr ap Xlookup kay sath dy den to asan ho jaye ga

[@pravinnathan4159]

Well done.... its works and I was searching kind of solutions no foreign videos has this solution. Only this indian gave me... it

[@dr.muhammadafnantalib5941]

God bless you Deepak. Stay Happy.

[@anujmaurya3131]

excellent topic and elaboration on concept

[@sumitchauhan2852]

Acha laga video

[@atulshukal4072]

Good Sir aaj mera man bhar gaya sir

[@sudarshanbala9144]

Thanks sir this video very very helpful 😊for me.

[@sharibansari8072]

Aap ki sari vdo smjh me ati h

[@hafizadilsidiqisab2486]

Thank you so much sir ji I am frm Kashmiri j&k India .... U solved mine big problem ...

[@pradeep998422]

Very Good

[@nasertmv1454]

Great. You explained in a very professional way that anyone can understand easily. Thank you

[@banwarifageriaexcelclasses1447]

very educative tutorial .

[@DeepakEduWorld]

🤗🤗🤗😊😊

[@aiTechSolution]

Gzb smart se bhi smart lookup

[@nadimakhtar5337]

U r genius

[@reshmakerketta5678]

Lockdown me ghar per hu to apke video se bhaut kuch sikh gai hu thk u

[@rockon7905]

Good video... advance bhi baki ka batate ho

[@pradnyajambhale4955]

Thank you so much sir.

[@investingmadeeasyfinance1060]

Excellent explanation, thanks

[@yasindalvi3555]

thankyou very much brother very very useful content

[@desijugad1092]

Good job sir This trick ko mai 1 years se dhund rahath

[@jagu775]

Vvvvvv nice bro

[@timcraven3543]

Wow. You accomplished exactly what I was looking for. Thank you so much!

[@SIMRANKAUR-eg7nc]

This is an amazing method. If u want to know everything about vlookup including multiple match here is my must watch recommendation. kzbin.info/www/bejne/rJqXoJ99fM-hhJY

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@---tz2ug]

What's your phone no contact

[@saheb_sangaliya_dhuni_108]

"_" ye Chen Q lgya

[@saheb_sangaliya_dhuni_108]

Yha par ":" ye Q nhi lgya

[@priyankaajankar7789]

Is table me sir je mai Aayush Type karne bad me kuch bhi Data display nahi kar rha. Baki sab barabar display ho rha hai

[@priyankaajankar7789]

Can u share ur contact number Dost.

[@investingmadeeasyfinance1060]

Excellent explanation

[@nilanjanachoudhury8545]

Thanks a lot sir

[@VikramBhatilovekodial]

This was really very helpful. You solved my long time problem in one shot. Thanks a lotttt♥️

[@shambhuram8493]

Very Nice Explain Sir 🙏

[@rahulpatil6858]

very usefull for my office work thanku so much sir...

[@mohammedehsan5533]

What an wonderful explanation. Thanks for the work.

[@nitishpradhan7375]

That's i was finding sir 🙏🙏🙏 Bhagban me kabse yehi dhond rahathaa🙏🙏😘

[@kavysingh1332]

Thank you sir 🙏🙏🙏

[@7700hardik]

thanks this video helps me a lot. Got my intended result withing in minute

[@mineshsoni6126]

Very nicely explained.. very good... sir... very useful in my practical work place... Thanks a Lot...

[@rosyprakash]

Thanked what I was looking for...saved my day

[@nilrajvasudeo2769]

Thank you very much...! It helped me a lot..!

[@shaileshparmar175]

Thanks dost

[@thegioiquanhta4613]

very good

[@asifsadheer5152]

Great

[@amandeeppama5282]

I can't thank you enough. Such an amazing video. This is exactly what I was looking for. Keep up the good work.

[@chandnijaiswal9029]

You are the best Thanku sir🤗🤗🤗🤗🤗

[@pradeepbeherag.3418]

Very Very Thanks venerable sir, I am Proud of you.

[@arjunsunar8570]

Thank you so much

[@bikramaggarwal4900]

Waoo. Thanks GURU JI. i got my answer by this video. THANKS. thats the method i was want to know

[@DeepakEduWorld]

😇🤗

[@ramashankargupta2904]

Sir This is very usefull video thanks for learning for this excel formula

[@mrsmanpreetmahal]

Helpful video of vlookup 🙏🏻

[@sonabillo]

Hi Mr. Deepak, you have created a very informative video. I have followed the same instructions using the Vlookup function. All things work perfectly except date. It cant copy the date from the data.

[@chikoogangraj7990]

Gajab Sir

[@DeepakEduWorld]

😊

[@SUBJECTGYAN]

वेरी वेरी थैंक्स सर मेरी कई दिनों से यह समस्या का समाधान नहीं हो पा रहा था आपके प्रयास से मेरी समस्या का समाधान हो गया है इसके लिए आपको विशेष धन्यवाद वाकई मैं स्ट्रीक के लिए और इस फॉर्मूले के लिए आपका बहुत बहुत आभारी रहूँगा। वाकई आई एम वेरी हैप्पी सर By सब्जेक्ट ज्ञान यूट्यूब चैनल

[@DeepakEduWorld]

😊

[@reshmakerketta5678]

Thk u, good teaching