How to apply VLOOKUP on Large / Big Data in Excel (Hindi)
ฝัง
- เผยแพร่เมื่อ 7 ต.ค. 2024
- Download Practice File 👉 techguruplus.c...
Buy Excel & Word Course 👉 TechGuruPlus.com
Download All Projects 👉 techguruplus.c...
.
Telegram Group 👉 t.me/TechGuruPlus
My Instagram 👉 / techguruplus
Facebook Group 👉 / excelexpertgroup
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
(1) Excel Videos
🔹 • Top 20: Advanced Excel...
(2) Tally Videos
🔹 • Email through Tally wi...
(3) Sponsored Videos
🔹 • Edraw Max: Perfect Sof...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Contact for Business Inquiry
➟ nazim.khan09@gmail.com
➟ Website: www.TechGuruPl...
#Call_9536250020_to_Join_Advance_Excel_Course #TechGuruPlus #NazimKhan
Buy Excel & Word Course 👉 TechGuruPlus.com
Download Practice File 👉 techguruplus.com/vlookup-on-large-big-data-in-excel/
Download All Projects 👉 techguruplus.com/excel-project-practice-files-download/
Sir simple vlookup formula se bhi ho rha sare values shi ayi A
Hello as you explained in the video if there are category like 5 brands each brand has monthly sales targets for 5 stores or persons how do we use vlookup in this scenario
I could send you a image if there is an option
Sir App phele jaha V lookup apply Krna hai un sare cells ko select kr lejea uske Bad Ume Vlookup ke sath Match function use kijea Formula auchhe se Lekne ke bad Cntrl hold krke Enter dba dijea Isse sare cell me ek Bar me V lookup apply Hojayega
2:47 sir मेरी एक sheet है usame date wise जेसे 1-2-2023 pir 1-3-2023 with number उसकी details bi aajaye
Thank you so much sir, सर मुझे ये कॉलम फंक्शन से आता था vlookup, लेकिन मैं जब कभी भी लगाता था थोड़ा सा कंफ्यूज हो जाता था, लेकिन आपने इतना आसानी से समझाया की जिंदगीभर के लिए दिमाग में बैठ गया। थैंक यू अगेन सर जी🙏
Great Brother 👍🎉
Aap job kha krte ho bhai
Kuch help chahiye aap se
Thank you so much ye formula clear ho gya mera....bahut sare video dekhe pr apke video se clear hua doubt
Really helpful practice file ,thanks pls keep giving us such practice file so that we can practice nicely .Thank you sooo much .
Awesome sir ji❤...Aap best teacher ho sir ji❤ek ek step aap ne samjhaya 🙏
Thanks for appreciating 🙏🍀
@@business-excel sir ji apko Dashera ki dher sari subhkamnaye🙏🙏
Thank you sir 😢 🙏 Vlookup me bahut jyada problem aata tha but aapne Aaj clear kar diya hai... Me aapka Excel ka cource purchase krunga 🙏
welcome
Highly appreciate it and highly recommended, very well explained extremely helpful thank u sir.
Thank you Sir So Much . सर मै आफका विडियो देखत रहेता हु और एक्सेल मे बहुत जानकारी लि है काम कर्नेमे सफलता मिलि है ।
Thank you so much sir aapka tarika bahoot easy to learn hai first time aapka video dekha big fann..❤😊
the best explanation of vlookup in the most simplest way, all the best Sir..
I did it with using vlookup match and hlookup match both ways.....thankyou for your trick also
boht sari videos h lookup cy related but jo apna smjhaya h na sir hatsoff
Mene kitne video dekhe ES k liye par samjh nahi ayya
Aap ne bohot badiya tarike s samjya . 👍
Bahut achche se app ne explain kiye hai vlookup ke bare me thanks sir❤
Thank you so much sir aap ne confusion dur ki....❤.....aap ne easy way bataya😍
Thank you sr VLOOKUP formula btaya aapne bhut help mila thanks
Really😮 यहां तो 9 से 10 हजार देके भी इतना गहराई से नही समझ पाया
पर आपके एक video में इतना मैं समझ गया
ऐसे ऐसे भी लोग होते जो education के नाम पे लोगो को लूट रहे है
काश मै ये video कुछ महीने पहले देख लिया होता आपके यहां से ही मैं copmuter का full corce कर लेता मेरा टाइम बच जाता 😢
Thank you sir मैं laptop खरीद कर आपसे जरूर मैं ये excel का advance कोर्स करूंगा
I have more simple trick for this
Really good stuff, thanks for sharing & updating our knowledge.
Awesome bhout aacha se explain kiya sir Aap na...😊
I am from Pakistan and very thanks for your easy understandable video of Vlookup
Thank you soooo much sir mai bahut dino se ye try kar raha tha nllekin mujhe samajh me hi nahi aa raha tha aap ka ye video dekh kar samajh me aa gya
Your most welcome 🙏
Thank you for saving my job and izzat ❤️
It's very important video
बहुत बहुत आभार sir आपका
Sir, you are too good with this!! Thanks a ton!! Really God bless you
🙏🙏
@@business-excel Is data main vlookup ki jaga exact+match function bhi use kar sakhte hai na?
YOU HAVE DONE MY WORK SO EASY I HAVE DONE ONE CHANGE IN PLACE OF COUMN I HAVE WRITTEN ROW(CELL) AND I GOT EXACT RESULT AS PER MY DATA THANK A LOT DEAR
Excellent sir, make understand hard thing in easy way, it is your great skill. thanks
best one is 6.48 sec... seems like you are matured content creator...how did i missed you on youtube...
Thanks buddy
Thank u brother it's really helpful for me. Imran Ahmed from Pakistan.
Pakistan me bhi excel use krte hai?????
Bomb spot krne ke liye thikane dundh ne ke liye kya
Thanks a Lot.. Bahut Vadiya kaam kiya
Thank you, sir. it's really help for me.
Glad to hear that
Sir Dil se thanku very very nice video Dil se shukriya
Very valuable formula. Thanks 🙏 so much.
VLOOKUP , HLOOKUP - Bahut Important Formula hain yeh, Bahut Interview meh puchte hein ❤
this is the best way of learn very nice sir
THANK YOU SO MUCH SIR LOTS OF LOVE FROM NEPAL
Thanks you too
Wonderful explanation sir great 👌👌
Very Nice
Thanks for explaining in simple
Thank you , helpful practice file 💯
Best sir and good understanding way of excel knowledge 🙏
Perfect sir
Thank You Sir,
Please Basic To Advance Excel Video Upload
Sir mujhe thoda bhi nahi aa rha tha but ab samjh me aa gya
Informative video sir 👍👍
Thank you Sir
You are Great sir🙏
thanks Sir Very Helpful
Bhai you are doing very good job thanks for such video this is realy helpfull.
Thanks Hitesh ji
Thanks so much sir for great information
Thank you sir j
So greatful to you
धन्यवाद सर जी
Thanks for taking it so efficient manner
Looking that from years
Thanks alot
Wlcm Naveen bhai
Really helpful file.thank you soo much.
Thanku so much for the much needed help🙏
Thanks bro... Simple and good
Thank you 😊😊😊
Nic sir bahut badhiya..🙏🙏🙏
M itni der se try kar rahi thi ab hua h 🥰
@@ChetnaChauhan-hp1jy Great
Nice video sir ❤
WOOOOOOO. THANK YOU SIR
Even without using Column function and locking I got the values without error, 👀
Bahut badiya
Tq so much
Useful
Excellent teaching bro 👌
really help full sir
Excellent job sir
Very well explained great 👍🏿
Thanks
Thanks
Thanks 🙏 sir
i dont know hindi but i did understand all..its a mix of english -spanish- portuguese
Thanks u Sir, for helping
Thanks so much sir
Great👍
Thank you
VERY GOOD , U R EXELLENT , THANKS
Thanks sir really helped me a lot. But sir when iam applying for data which have random columns tab kaise lagega ye formula. For ex yaha 1st jan ki ki jagah 2 jan uske baad 5 jan aise random hota to kaise ek baar me data late. Please help
Tq sir❤
Can we generate students annual report by using excel sheet in word document....character report basing on there performance in each subject
Great yr
Thanks u sir for you give us practice sheet❤❤❤
Yahi to chahiye tha 🙏
Very nice teaching
Very nice explanation
Thanks
Very EASY TO Understand sir ji
😇
not woeking at all in dragging downwards by using column(B1), here always coming the first value to the downwards cells of that column.
update: it works when I used Columns(B1:C1) and without locking anything. [This works but this is not right way. ]
I apologise, your method is right I was wrong, Thank you.
Hello Sir.
Thank you so much. The way you teaching is really easy to understand, thumbs up.
*
B. Regards.
-NasiR.
Discover the game-changing formula that will make you say goodbye to Vlookup, Hlookup, Index+Match, and Xlookup. Trust me, your perspective will never be the same!
Just Search on Google
"Say goodbye to Xlookup"
Sabse best l... Vlookup with match.. Row rows column and columns kii need nahii hotii jab hum v lookup with match use karte h to.. Isliye best option match rehta h
Sir ji very nice 👌
Excellent
Thanks
Thank you sir ✨
Very nice thank you❤
Thank you... really helpful
Wonderfull Sir ji
Sir Nazim ,I am from Karachi Pakistan your computer course are helpfull for my office work. Can join your computer couse
Yes you can join on my website techguruplus.com/excel-course
Thank you so much for this video
Thanks a lot sir exactly i needed this one
That' very helpful. Thanks..