🤓Extract All Data Of Same Repeated Lookup Value 👍 Using Vlookup In Excel || Hindi
Вставка
- Опубліковано 6 лют 2025
- 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
Vlookup Full Tutorial Basic to Advanced
ua-cam.com/video/V4YgQTFLmyc/v-deo.html
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
ua-cam.com/video/-W9A9mSKpHQ/v-deo.html
8200794895 Contact me sir
@@gelotylashtash4665 l
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
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
What's your phone no contact
"_" ye Chen Q lgya
Yha par ":" ye Q nhi lgya
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
Can u share ur contact number Dost.
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.
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
🤗🤗🤗😊😊😊😊😊
Keep learning.. keep supporting 🤗
दीपक मैंने आज आप का वीडियो देखा । सही मायने में आप गुरु हो। Excel पर आपका कमांड जबरदस्त है।
sir abhi tak aap jaisa clear video pure UA-cam main kahi nahi hai
वेरी वेरी थैंक्स सर
मेरी कई दिनों से यह समस्या का समाधान नहीं हो पा रहा था आपके प्रयास से मेरी समस्या का समाधान हो गया है इसके लिए आपको विशेष धन्यवाद वाकई मैं स्ट्रीक के लिए और इस फॉर्मूले के लिए आपका बहुत बहुत आभारी रहूँगा। वाकई आई एम वेरी हैप्पी सर
By सब्जेक्ट ज्ञान यूट्यूब चैनल
😊
Ap se bada koi master nahi you tube par
want to learn office 2019 and office 365
Great Sir... You are saving my 1/5 times of my office work... Thank You Sir.
Thanks!
Thank you Mr. Deepak after long time searching i got this helpful video many thanks
Happy to help 😊
Sir ji........mere khvais puri karhi di aaap ne........ Thanks..........🙏🙏🙏
I love this channel............Yes you're ON..........
Duplicate value in vlookup wale comment ka sahi jawab hai . Thanks
Well done.... its works and I was searching kind of solutions no foreign videos has this solution. Only this indian gave me... it
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.👌👌👌👌✌✌
Bhai g bhot bhot dhynywaad apka mera sara kaam isi k chkkr me atka pda tha tnks a lot deepak sir
Great sir,
Kamal kar diya aapne sir
मज़ा आ गया सर ।
excellent topic and elaboration on concept
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
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.
Thank you sooo much
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. :)
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.
Very nice presentation
Wonderful explanation keep it up
Lockdown me ghar per hu to apke video se bhaut kuch sikh gai hu thk u
Thank you so much sir ji I am frm Kashmiri j&k India .... U solved mine big problem ...
Aap ki sari vdo smjh me ati h
👌 video Deepak
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..🙏
😁👍👍👍
Very informative... thank you for sharing
Thanks you so muchhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
It was my need today..........................From Pakistan Punjab Faisalabad
thanks Deepak for Excellent explaination -
Thank you thank you thank you...so much sir....!!!! U resolve my problem...!!!!
This formula is very useful for Those who doesn't have excel 360
Very nicely explained.. very good... sir... very useful in my practical work place... Thanks a Lot...
Great. You explained in a very professional way that anyone can understand easily. Thank you
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
Sr Bina vba ke cash book entry ke liye koi vedio bnao Sr ...jisme monthly data or yearly data print.....edit...new work entry ...search .......aap bhot acha or detail se samjate ho sr.....or aasani se samj me aa jata h sr
😊😊🤗🤗👍👍👍 as soon as possible
Thanks for sharing 🙏
जबरदस्त सरजी. U r great
Tanks you so much sir great job 🙏👍
Well explained deepak
Dada Nomoskar. Just Wow.
Graphic image you title is to the point, and excellent presentation
Thanks sir it's very useful for me at workplace
Dear Deepak very useful.
Thanks sir for this video and also like all video for extra knowledge
Dear sir it's very helpful tips
Thank you very much for the vedio and good explination with details
Deepak you are doing great job,
Keep it up 👍👍
Thank you for very useful vedio
This can also be used to bring values from adjacent cells at one place of duplicate items & identify the differences between them. Good demo. 👍🏻
You are the best
Thanku sir🤗🤗🤗🤗🤗
Really helpful. Thanku so much 🎉
I saw your video on you tube and I taught my computer teacher this trick.
lean more office 2019 and office 365 new formulas and new function
please visit my channel also.
for vlookup
ua-cam.com/video/1noGHCUGxUM/v-deo.html
Channel link
ua-cam.com/channels/Yalru61E3cHHeHqHW3cT_A.htmlabout
God bless you Deepak. Stay Happy.
This was a wonderful explanation - very clear and to the point. Very helpful. God Bless you!
Very very thanks this video helps me alot
GOOD INFORMATION
Good job Deepak 👏👏👏
bhaut badiya sir
very educative tutorial .
🤗🤗🤗😊😊
Good Sir aaj mera man bhar gaya sir
Thank you so much sir. You have solved my big problem. I am looking since long time this solution
All Excel Lookup Function: ua-cam.com/play/PLl2uwOt1hHQtb5FzyeJezM3bzZAm2B1qr.html
Gzb smart se bhi smart lookup
Awesome 👍
Nice very good
You are superb bro...👌👌👌👌👌
Acha laga video
Sir This is very usefull video thanks for learning for this excel formula
bohat allaha or lajawb video sir thanks
Gajab Sir
😊
Ek no. Bhai, advance formula
Helpful video of vlookup 🙏🏻
Very good Sir Thenks
I can't thank you enough. Such an amazing video. This is exactly what I was looking for. Keep up the good work.
Thanks sir this video very very helpful 😊for me.
What an wonderful explanation. Thanks for the work.
Very Nice Explain Sir 🙏
Great sir
That's i was finding sir 🙏🙏🙏
Bhagban me kabse yehi dhond rahathaa🙏🙏😘
@ great vedio
Sir filter karka..yea to kar sakta hey?
Thank u sir just great idea
Amazing sir
Very useful 👌
Good Idea
That's really great
Excellent explanation
Very Good
Good video... advance bhi baki ka batate ho
Awesome video sir thank you so much 🙏
You are awesome. I got what I was looking for. Best Technique.
Thank u Deepak sir
Excellent explanation, thanks
Bro it's really amazing ...keep it up bro 😍
👍 I was looking for this since long time
I had been looking for this for a long time. Grammatical correct
Super...nicely explained....
thanks this video helps me a lot. Got my intended result withing in minute
Deepak sir aap gjb ho thanks..... Nice video
This was really very helpful. You solved my long time problem in one shot. Thanks a lotttt♥️