EXTRACT ALL DATA OF REPEATED LOOKUP VALUE USING VLOOKUP INEXCEL|VLOOKUP WITH DUPLICATE LOOKUP VALUES

  Рет қаралды 49,870

SHIVAM EDUCATION WORLD

SHIVAM EDUCATION WORLD

Күн бұрын

EXTRACT ALL DATA OF REPEATED LOOKUP VALUE USING VLOOKUP IN EXCEL TO CREATE MIS REPORT.
VLOOKUP WITH DUPLICATE LOOKUP VALUES
using countif formula every excel user must know.
Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World.
SUBSCRIBE TO MY CHANNEL 👉 kzbin.info....
This EXCEL tutorial will help you how to lookup repeat data, like a name is repeated many times in your data and you need to find #vlookup is an important function at this time.
This is the best video to learn IF ERROR formula in excel
#vlookup
#msexcel
#shivameducationworld
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 dene ki poori koshish karunga.
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...
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 in excel,shivameducationworld,extract all data of same lookup value using vlookup in excel,vlookup multiple lookup,vlookup in multiple workbooks,vlookup multiple lookup values,if error vlookup,vlookup with duplicate values,vlookup repeated data,vlookuprepeated values,excel tutorial,vlookup duplicate values

Пікірлер: 65
@Mdtechq
@Mdtechq 3 жыл бұрын
really sir g bohat acha guide kia aap nay
@shivameducationworld
@shivameducationworld 3 жыл бұрын
thank u
@ashish365
@ashish365 3 жыл бұрын
Nice video helpful video
@MuhammadUsmanTaj
@MuhammadUsmanTaj 3 жыл бұрын
Good
@rehanalam0522
@rehanalam0522 3 жыл бұрын
Very good
@monalisachakraborty110
@monalisachakraborty110 Жыл бұрын
👍
@mohammadilyas2260
@mohammadilyas2260 2 жыл бұрын
زبردست Excellent
@shivameducationworld
@shivameducationworld 2 жыл бұрын
Thank u
@pradeepkumarbehera5692
@pradeepkumarbehera5692 3 ай бұрын
Nicely elaborate
@sanathsaja9840
@sanathsaja9840 3 жыл бұрын
U r the best teacher for me
@abhisheksrivastava-sh6pp
@abhisheksrivastava-sh6pp 3 жыл бұрын
Thank you sir best video on vlookup.
@wahidrashid4865
@wahidrashid4865 2 жыл бұрын
Very beautiful sir
@mansoorahmed2484
@mansoorahmed2484 3 жыл бұрын
Demo dekhkr hi like kiya.
@Noumanjavedshamsi
@Noumanjavedshamsi 3 жыл бұрын
I like video sir
@ashishjain6789
@ashishjain6789 3 жыл бұрын
Thanks
@deepalig4407
@deepalig4407 3 жыл бұрын
Really best video of your sir...thanks for sharing valuable tricks and knowledge..🙏🙏🙏
@ravichauhan3933
@ravichauhan3933 8 ай бұрын
very nice video
@shivameducationworld
@shivameducationworld 8 ай бұрын
Thank U
@ShivamSingh-uj8ld
@ShivamSingh-uj8ld 3 жыл бұрын
Sir,thank u very much,aapne best sikhaya hai.
@venkatiyer7459
@venkatiyer7459 3 жыл бұрын
Accidentally came across to this video.... very useful one Sir ... thanks
@jitukumar9754
@jitukumar9754 Жыл бұрын
Very nice video 👍👍
@user-sx7qm3be1c
@user-sx7qm3be1c 2 жыл бұрын
Thank you
@vivekkumarsingh9140
@vivekkumarsingh9140 Жыл бұрын
आपका जो कंटेंट है वह पूरे यूट्यूब का नहीं मिलेगा और आपका यह कार्य सराहनीय है जो लोगों को आसानी से समझने में में मदद करता है
@shivameducationworld
@shivameducationworld Жыл бұрын
Thank U
@khushisingh6468
@khushisingh6468 3 жыл бұрын
U r the best teacher for me 💯
@tt_badmash_9560
@tt_badmash_9560 8 ай бұрын
You are excellent
@shivameducationworld
@shivameducationworld 8 ай бұрын
Thank U
@mohdsartaj9554
@mohdsartaj9554 Жыл бұрын
Accidentally come this video and such a very helpful video thanks guruji
@shivameducationworld
@shivameducationworld Жыл бұрын
You Are Most Welcome
@Growthingstock
@Growthingstock 2 жыл бұрын
VERY USEFULE INFORMATION THANKS FREINDS
@shivameducationworld
@shivameducationworld 2 жыл бұрын
Welcome friend
@UttamSingh-yd4ij
@UttamSingh-yd4ij 3 жыл бұрын
174 subscriber
@nasertmv1454
@nasertmv1454 Жыл бұрын
Very useful video. Explained in easily understanding way.
@shivameducationworld
@shivameducationworld Жыл бұрын
Thank U
@MaheshKumar-pt7gk
@MaheshKumar-pt7gk Жыл бұрын
Definitely you explain very well 👌👍
@shivameducationworld
@shivameducationworld Жыл бұрын
Thank U
@prashanttyagi1156
@prashanttyagi1156 2 жыл бұрын
Dear sir Jab bhi aap koi video post kerte hai uski practice sheet ka link saath mein jarur dale. Practice kerna mein help hogi Thanks
@sachinpathare9060
@sachinpathare9060 17 күн бұрын
sir alt+down arrow se data validation list kaise banayee. please explain me. unique value kisi list kaise banaye.
@usmanshafiq5077
@usmanshafiq5077 3 жыл бұрын
Table data my conditional formatting lagana b nai batae aur na formulas ki basic ya reasoning nai batai deeply
@vikassingh3526
@vikassingh3526 3 жыл бұрын
Nice sir agar same kaam karna ho per xlookup formula se to kese karenge pls tell
@muhammadsaqlain5162
@muhammadsaqlain5162 2 жыл бұрын
Kya offset funktion se possible hai? ager id no ek se zyada ho means duplicate ho aur id k base per data search kerwana ho to offset funktion se kaise krenge plz tell me.
@venkateshmadduri1157
@venkateshmadduri1157 3 жыл бұрын
I am urging a help that without having data validation, is possible to get the values on duplicate names with vlookup formula?. Kindly suggest.
@shivameducationworld
@shivameducationworld 3 жыл бұрын
kindly check this video- kzbin.info/www/bejne/gmPKk2huZbiKY7c
@r.ksahab6167
@r.ksahab6167 Жыл бұрын
Duplicate value ko mulple table se kaise lookup krain
@mukeshbhaipatel8793
@mukeshbhaipatel8793 3 жыл бұрын
Upload conditional formatting videos
@shivameducationworld
@shivameducationworld 3 жыл бұрын
Kindly check my Index Match series I have explained in detail. Thank u
@sagarmathur3535
@sagarmathur3535 3 жыл бұрын
How.to use vlookup without using helping column?
@shivameducationworld
@shivameducationworld 3 жыл бұрын
check this video- kzbin.info/www/bejne/oXOln5yqn5d7hrs
@user-ik3cj7bn2g
@user-ik3cj7bn2g Жыл бұрын
sir mujhe Aapki video Elsa's best Laga lakin Sir highlights ni gotcha column
@gauravrawat4072
@gauravrawat4072 3 жыл бұрын
Drop down list m unique name kaise aaye kyk mere wo sare aa jate hain jo list m hain chahe 2 bar ho ya 10 bar
@shivameducationworld
@shivameducationworld 3 жыл бұрын
remove duplicate se . check this video- kzbin.info/www/bejne/oXOln5yqn5d7hrs
@Levi-vb1nq
@Levi-vb1nq 2 жыл бұрын
please help me to do like your teach cos i can not do the same you
@khalidmajeed2886
@khalidmajeed2886 Жыл бұрын
sir how we do it in power query
@tanmaypandya1102
@tanmaypandya1102 4 күн бұрын
Red में highlight कैसे होता है
@MrDevashish1
@MrDevashish1 3 жыл бұрын
is there any other way to do this instead of vlookup ?
@shivameducationworld
@shivameducationworld 3 жыл бұрын
YES, Advance Filter
@rahulngokumar8802
@rahulngokumar8802 Жыл бұрын
Please provide sheet also
@iftakharhasan3292
@iftakharhasan3292 Жыл бұрын
please provide the excel sheet of this project
@jorgedelchiaro9377
@jorgedelchiaro9377 2 жыл бұрын
Faltó el Archivo de bajada.....
@nitinjadav1868
@nitinjadav1868 Жыл бұрын
सर आपका संपर्क कैसे करे
@Levi-vb1nq
@Levi-vb1nq 2 жыл бұрын
sorry i can not do
@shivameducationworld
@shivameducationworld 3 жыл бұрын
Support me friends 👍 and subscribe to my channel✅
大家都拉出了什么#小丑 #shorts
00:35
好人小丑
Рет қаралды 86 МЛН
ДОКАЗАЛ ЧТО НЕ КАБЛУК #shorts
00:30
Паша Осадчий
Рет қаралды 1,9 МЛН
Alat yang Membersihkan Kaki dalam Hitungan Detik 🦶🫧
00:24
Poly Holy Yow Indonesia
Рет қаралды 11 МЛН
Excel FILTER Function - Lookup to Return Multiple Values
9:22
Leila Gharani
Рет қаралды 703 М.
Vlookup Duplicate Repeated Values  in Excel in Hindi
8:59
My E-Lesson
Рет қаралды 229 М.
Vlookup Duplicate Lookup Values in Hindi MS Excel
6:22
Switch With Tech
Рет қаралды 9 М.
Excel VLookup to Return Multiple Matches
6:55
The Excel Cave
Рет қаралды 220 М.
Return Multiple Match Results in Excel (2 methods)
14:13
Leila Gharani
Рет қаралды 1,9 МЛН
Pivot Table in Excel - Malayalam Tutorial
16:17
XL n CAD Malayalam
Рет қаралды 222 М.
大家都拉出了什么#小丑 #shorts
00:35
好人小丑
Рет қаралды 86 МЛН