How to apply VLOOKUP on Large / Big Data in Excel (Hindi)
Вставка
- Опубліковано 25 сер 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
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🙏🙏
boht sari videos h lookup cy related but jo apna smjhaya h na sir hatsoff
Really helpful practice file ,thanks pls keep giving us such practice file so that we can practice nicely .Thank you sooo much .
Thank you Sir So Much . सर मै आफका विडियो देखत रहेता हु और एक्सेल मे बहुत जानकारी लि है काम कर्नेमे सफलता मिलि है ।
Thank you sr VLOOKUP formula btaya aapne bhut help mila thanks
the best explanation of vlookup in the most simplest way, all the best Sir..
Thank you so much sir aap ne confusion dur ki....❤.....aap ne easy way bataya😍
बहुत बहुत आभार sir आपका
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
Thank you so much sir aapka tarika bahoot easy to learn hai first time aapka video dekha big fann..❤😊
Bahut achche se app ne explain kiye hai vlookup ke bare me thanks sir❤
Really😮 यहां तो 9 से 10 हजार देके भी इतना गहराई से नही समझ पाया
पर आपके एक video में इतना मैं समझ गया
ऐसे ऐसे भी लोग होते जो education के नाम पे लोगो को लूट रहे है
काश मै ये video कुछ महीने पहले देख लिया होता आपके यहां से ही मैं copmuter का full corce कर लेता मेरा टाइम बच जाता 😢
Thank you sir मैं laptop खरीद कर आपसे जरूर मैं ये excel का advance कोर्स करूंगा
I have more simple trick for this
Awesome bhout aacha se explain kiya sir Aap na...😊
Highly appreciate it and highly recommended, very well explained extremely helpful thank u sir.
Thanks a Lot.. Bahut Vadiya kaam kiya
Mene kitne video dekhe ES k liye par samjh nahi ayya
Aap ne bohot badiya tarike s samjya . 👍
Sir Dil se thanku very very nice video Dil se shukriya
Really good stuff, thanks for sharing & updating our knowledge.
Vlookup with match sbse best hai hai,
Very well explained great 👍🏿
Thanks
this is the best way of learn very nice sir
Thank you, sir. it's really help for me.
Glad to hear that
Thanks for explaining in simple
M itni der se try kar rahi thi ab hua h 🥰
@@ChetnaChauhan-hp1jy Great
I am from Pakistan and very thanks for your easy understandable video of Vlookup
Nic sir bahut badhiya..🙏🙏🙏
Very Nice
Wonderful explanation sir great 👌👌
VLOOKUP , HLOOKUP - Bahut Important Formula hain yeh, Bahut Interview meh puchte hein ❤
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
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 🙏
Perfect sir
Sir mujhe thoda bhi nahi aa rha tha but ab samjh me aa gya
Very nice 👍
I did it with using vlookup match and hlookup match both ways.....thankyou for your trick also
THANK YOU SO MUCH SIR LOTS OF LOVE FROM NEPAL
Thanks you too
Very valuable formula. Thanks 🙏 so much.
Thank you sir j
So greatful to you
You are Great sir🙏
Thank you for saving my job and izzat ❤️
Thanks so much sir for great information
Thank you 😊😊😊
WOOOOOOO. THANK YOU SIR
thanks Sir Very Helpful
Thank you , helpful practice file 💯
Well explained 👍
Thank you sir
VERY GOOD , U R EXELLENT , THANKS
Bahut badiya
Yahi to chahiye tha 🙏
Excellent job sir
धन्यवाद सर जी
Thank you so much
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?
Thanks bro... Simple and good
Thank you ❤
Great👍
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
Tq so much
Thank you❤
Thanks u guru ji
Looking that from years
Thanks alot
Wlcm Naveen bhai
Excellent sir, make understand hard thing in easy way, it is your great skill. thanks
Superb sir
Best sir and good understanding way of excel knowledge 🙏
Thanks 🙏 sir
really help full sir
best one is 6.48 sec... seems like you are matured content creator...how did i missed you on youtube...
Thanks buddy
Thank You Sir,
Please Basic To Advance Excel Video Upload
Very helpful.
Thank you so much, it will help me
Thanku so much for the much needed help🙏
Very nice teaching
Sir ji very nice 👌
Even without using Column function and locking I got the values without error, 👀
Really helpful file.thank you soo much.
Zabardast
learning
Thanks
Thank you
Wonderfull Sir ji
Excellent teaching bro 👌
Thanks u Sir, for helping
Thanks for taking it so efficient manner
Excellent
Thanks
Thanks You
Bhai you are doing very good job thanks for such video this is realy helpfull.
Thanks Hitesh ji
Tq sir❤
Very nice thank you❤
Very nice explanation
Thanks
Nice sir g
Thanks u sir for you give us practice sheet❤❤❤
That' very helpful. Thanks..
We can use xlookup function instead of vlookup....and this is more simple than vlookup
Thank you so much for this video
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.
Good
Thank you... really helpful