Very knowledgeable video that too for free🔥 is video ko dekhne se pehle tak mujhe vlookup kbhi aise smjh nhi aaya ki yaad reh ske but bhaiya is video me aapne bhut achhe se saare formulae smjhaye... Hopefully ab yaad rhenge
Thank you Mera kl Interview h, excel Mera itna khaas nhi h , aapki videos Dekh kr seekh Rahi hu Thanks videos bnaane k liye, Canada meh reh kr bhi ache se smjh skti hu aapki videos k through 😊 Hum Indians ki Baat hi alg h koi bhi dusri country ka bnda iss traah SE nhi smjhaayega Jesse AAP smjha rahe ho
Wahh sir bohot bohot search ke bad aap ka excel learning videos mast he , so so thanks sir 🙏🙏🙏, aapka koi paid subscription full advance Excel tutorial he to plss boliye 😊
Truly said🥰 very knowledgeable video that too for free🔥 is video ko dekhne se pehle tak mujhe vlookup kbhi aise smjh nhi aaya ki yaad reh ske but bhaiya is video me aapne bhut achhe se saare formulae smjhaye... Hopefully ab yaad rhenge
Hi Deepak sir Your training videos are awesome. A small correction in training file is needed for second example (search by product): Product ID P2 and P8 have same item name I.e. Monitor. (Duplicate) Lookup value in a table array must have unique one. I hope you got my point. Thanks!
Excellent sir thank you for such a great explanation much helpful 💯💯💯 Ek help chahiye sir for example mere lookup value hai 12345 and table mei wo same chiz hai par 012345 i mean ye example mai apne office ke exported file ki dera hu jisme product ka SKU no tha toh exported file mei SKU no ke pehle 0 laga hua aara hai I mean example jo maine diya actual SKU hai 12345 and exported file mei 012345 hai toh isko kaise sort krenge mere colleague ne mujhe btaya ki exported file mei SKU ka format change krna hoga number mei toh kya ye sahi hai ya iska aur koi dusra tarika bhi hai??? Please reply bht help hogi thank you
@deepakeduworld if we were to remove data from the Table, it has to be updated dynamically. Kindly update on that formula as well. Like, the blanks from the tables has to be removed if we remove data from the table.
Very nice …. ❤ But i have 1 Question please get some solution. Agr mera pehle column mn 4 Cell merged he anr 2nd column mn Aik lookup value k liyye 4 Diffrent row mn data he to kyse show hoga.
Sir kya ye vlookup hack vala multiple Records vale formula mai column formula ki jgh curly brackets vala hack use kare to kya kaam karega?????? Plz reply as soon as possible☺
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![Advance Filter on Large Data in Excel | Filter vs VLOOKUP | [Hindi] #excel](/img/n.gif)
Dosto Kaisa laga ye video ? training file download kar lo link video ke description me de rakha hai....
Bohat amazing lecture tha Sir
Sir ms word ki hidden tricks mujhe pata hai aapko btao bohat kaam ki tricks hain Sir aapko bataon
Sir plzzz reply karein btaiye ms word ki tricks btaun aap uska video bana sakte hain
Useful
❤
Very knowledgeable video that too for free🔥 is video ko dekhne se pehle tak mujhe vlookup kbhi aise smjh nhi aaya ki yaad reh ske but bhaiya is video me aapne bhut achhe se saare formulae smjhaye... Hopefully ab yaad rhenge
Execellent... सरल और सहज..
ट्रॅक बाय ट्रॅक.. टीचिंग
ap bahut hi acche se sajha rahe ho. Thank you.
Good knowledge sharing video
Aisahi over all usage dekar post se concept clear hota hay. Thank you. ❤
EVERY FORMULA WAS AWESOME
Very Informative video.
Very helpful information n video
Bohut achha laga sir jii...
A very helpful video Sir, easy to understand with nice illustrations 🌹👍
Glad you liked it! 😊
reverse vlookup i didn't know before watching this video. Many many Thanks .
Thank you
Mera kl Interview h, excel Mera itna khaas nhi h , aapki videos Dekh kr seekh Rahi hu
Thanks videos bnaane k liye, Canada meh reh kr bhi ache se smjh skti hu aapki videos k through 😊
Hum Indians ki Baat hi alg h koi bhi dusri country ka bnda iss traah SE nhi smjhaayega Jesse AAP smjha rahe ho
Thanks g 🙏 and best of luck for interview..
Apka to koi jwab nhi sir tnx
Jatt bhai
Aapne to गर्दा उड़ा दिया।।।
Very nice video
❤️🙏
sir g ap ne sirf asi 1 video pr meri sb se bari problems solve kr di dynamic vlook k through . thanks a lot
th-cam.com/users/shortsNx--_KM0zJs?si=pmQrt5dxrK7iiJ61
Bahot badhiya
vlookup Hack wala naya learning tha .. Thanks
Best video for who want to learn Vlookup in advance level.👏
Bahut hi acha video banae hai sir aap really very understandable thankyou so much
Perfect video for v lookup who wants to learn
YOUR TEACHING STYLE IS AMAZING SIR, TAUGHT MANY COCEPTS ONLY IN 35 MINUTES WITHOUT WASTING TIME IS INCREDIBLE EFFORT BY YOU.
THANKYOU
Awesome
Awesome brother…
Mere colleagues ko vlookup use krna nhi aata, there now i can proudly say mujhe aata h aur uska sirf basic formula nhi balki saare types aate hn💯🧿❤️
Bohot accha video hai ❤❤❤❤🎉🎉❤❤
Sir many many thanks for this class
best video to learn vlookups trick
Awesome aaj bahut kuch Vlook up me सीखने ko mila Deepak sir. Thank you so much your teaching way is very perfect 😊
Most welcome 😊
Sare hi bdiya the bhai ji
I really enjoy this video really help to me
Bohot achhe ham bhi esi tarah bachho ko Training dete han
Thanks man
A very informative video. Thanks for sharing such a precious knowledge.
wonderful tutorial dost. aage bhi aise videos banate rahen... speciallly Array concept ke upar
Top notch explanation 👌
Thank you very much sir
Very very helpful video 🎉🎉🎉🎉🎉
20:04 and 26:17
Awesome video sir... thanku...🎉
Bahot accha laga
So helpful, Thank you so much.
Very good information
thanks so much for this video..really very clear explanation with all important formulas of vlookup at one place...keep up with the great work.
Thank you so much for this wonderful tutorial Sir❤🙏
❤❤Awsome❤❤❤
Fruitful sirji🙏🙏🙏
Very nice 👌
I learned a lot from you
Very very best video thanks
Amazing thankyou
Very informative video❤
Awesome sir g❤❤❤
Mai kab se vlookup ki advance video khoj rha tha. Finally i found it.
very helpful video
Just amazing ❤️
Thank you 🙏❤ sir
That 8th formula is crazy ❤
Wahh sir bohot bohot search ke bad aap ka excel learning videos mast he , so so thanks sir 🙏🙏🙏, aapka koi paid subscription full advance Excel tutorial he to plss boliye 😊
Thank you so much sir
All are superb
17:50 For This Normal Vlookup formula working fine Also
Thank you sir ji ❤
Excellent Sir,
Mujhe vaise to Puri video hi bahut pasand aai lekin jo aapne choose formula lagaya vo bahut bahut mast laga.
Thanks g 😊
Mast ho aap
Perfect video
Thankful❤❤❤
Great sir
Very useful
Boss tussi grate ho awesome Jai hind sir Deepak Lucknow ❤❤
th-cam.com/users/shortsNx--_KM0zJs?si=pmQrt5dxrK7iiJ61
vlookup hack working in my case
It feels illegal to watch this content for free❤️ I mean just amazing👏🏻
Truly said🥰 very knowledgeable video that too for free🔥 is video ko dekhne se pehle tak mujhe vlookup kbhi aise smjh nhi aaya ki yaad reh ske but bhaiya is video me aapne bhut achhe se saare formulae smjhaye... Hopefully ab yaad rhenge
Thanks bro❤❤❤❤❤❤❤
Hi Deepak sir
Your training videos are awesome.
A small correction in training file is needed for second example (search by product):
Product ID P2 and P8 have same item name I.e. Monitor. (Duplicate)
Lookup value in a table array must have unique one.
I hope you got my point.
Thanks!
एक ऐसा sheet जिसपर weekly, monthly, quarterly, half yearly तक का एक क्लिक पर किस्त निकल जाए। 🎉
Sir aise hi index and match ka bhi full tutorial bana dijiye.. plus (index+match)
Thank you sir
3:33 table array select krne ke baad fn+F4 nhi krna h kya table lock krne ke liye??
Great
Nice Sir
Deepak sir timestamp ki tara valuestamp k liye b koi function bata den please jis me source value change krny per result value change nhi ho...
❤😊🎉
❤❤❤❤ 🔥🔥🔥🔥🔥🔥
Nice
Welcome
👌
Excellent sir thank you for such a great explanation much helpful 💯💯💯
Ek help chahiye sir for example mere lookup value hai 12345 and table mei wo same chiz hai par 012345 i mean ye example mai apne office ke exported file ki dera hu jisme product ka SKU no tha toh exported file mei SKU no ke pehle 0 laga hua aara hai I mean example jo maine diya actual SKU hai 12345 and exported file mei 012345 hai toh isko kaise sort krenge mere colleague ne mujhe btaya ki exported file mei SKU ka format change krna hoga number mei toh kya ye sahi hai ya iska aur koi dusra tarika bhi hai???
Please reply bht help hogi thank you
Ho sakta hai sku number as text likhen ho.. number format me hi change karna padega.. ✅✅
@deepakeduworld if we were to remove data from the Table, it has to be updated dynamically. Kindly update on that formula as well. Like, the blanks from the tables has to be removed if we remove data from the table.
Thik to hai
😊
9:19 how to lock in laptop ?? F4 is not working
Use Fn+ F4 ✅
❤❤❤ 🙏🙏
Coulumns का नही मालुम धा.
धन्यवाद सर 🙏🏻
It's useful for large data?
sheet 9 aur 10, formula dalne ke baad value ek hi cell me aa rahi hai. sare cells me values nahi aa rahi hai... please guide...
Sir school student ke fee record vlookup se har month ki fee report kese banaye????
VLook up lgane k liye data same sheet pr hona chahiye....???
No.. kisi bhi sheet pe data ho sakta hai
Sir can we use it in our portfolio? For freelancing.
Yes.. definitely you can use it if required ✅
@@DeepakEduWorld thanks
Sir last tak formula lagane ke baad enter karna hain yaa shift+enter kyuki mera hsn code he aa raha hain
Aapne columns formula me ho range di hai uska dusra cell bhi lock kar diya hai.. aap video me fir se dekh k try karo ho jayega ✅
Very nice …. ❤ But i have 1 Question please get some solution.
Agr mera pehle column mn 4 Cell merged he anr 2nd column mn Aik lookup value k liyye 4 Diffrent row mn data he to kyse show hoga.
Sir kya ye vlookup hack vala multiple Records vale formula mai column formula ki jgh curly brackets vala hack use kare to kya kaam karega??????
Plz reply as soon as possible☺
Hanji ho jayega .. but ye old version me kaam nhi karega.. 2019 or later version me kaam karega
@@DeepakEduWorld Thank you sir
Choose and column