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
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!
@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☺
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
❤
Aisahi over all usage dekar post se concept clear hota hay. Thank you. ❤
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..
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
YOUR TEACHING STYLE IS AMAZING SIR, TAUGHT MANY COCEPTS ONLY IN 35 MINUTES WITHOUT WASTING TIME IS INCREDIBLE EFFORT BY YOU.
THANKYOU
Best video for who want to learn Vlookup in advance level.👏
Bohot accha video hai ❤❤❤❤🎉🎉❤❤
Perfect video for v lookup who wants to learn
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!
Mai kab se vlookup ki advance video khoj rha tha. Finally i found it.
Bahut hi acha video banae hai sir aap really very understandable thankyou so much
एक ऐसा sheet जिसपर weekly, monthly, quarterly, half yearly तक का एक क्लिक पर किस्त निकल जाए। 🎉
A very informative video. Thanks for sharing such a precious knowledge.
Thank you very much sir
Very very helpful video 🎉🎉🎉🎉🎉
20:04 and 26:17
Excellent Sir,
Mujhe vaise to Puri video hi bahut pasand aai lekin jo aapne choose formula lagaya vo bahut bahut mast laga.
Thanks g 😊
Fruitful sirji🙏🙏🙏
Top notch explanation 👌
wonderful tutorial dost. aage bhi aise videos banate rahen... speciallly Array concept ke upar
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.
Sir aise hi index and match ka bhi full tutorial bana dijiye.. plus (index+match)
Thank you so much for this wonderful tutorial Sir❤🙏
Sare hi bdiya the bhai ji
I learned a lot from you
Very useful
Awesome video sir... thanku...🎉
Awesome sir g❤❤❤
Bahot accha laga
Boss tussi grate ho awesome Jai hind sir Deepak Lucknow ❤❤
th-cam.com/users/shortsNx--_KM0zJs?si=pmQrt5dxrK7iiJ61
I really enjoy this video really help to me
All are superb
Thank you sir ji ❤
So helpful, Thank you so much.
Very informative video❤
Welcome
Thank you sir
Great sir
@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.
Thankful❤❤❤
Nice Sir
Thanks bro❤❤❤❤❤❤❤
Perfect video
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
Great
Sir can we use it in our portfolio? For freelancing.
Yes.. definitely you can use it if required ✅
@@DeepakEduWorld thanks
Nice
Choose and column
Sir (vlookup+match) vs (index+match) konsa best hain....?
❤❤❤❤ 🔥🔥🔥🔥🔥🔥
👌
columns lage k liye colums uper hi select karna hoga
Vlookup 3 sheet mein hlookup sahi ya jo aapne bataya vlookup wo?
Amazing video sir but mera curly bars function work ni kr rha h koi bta skta h kyu?
Practice file
choose
Sir vlookup ke saath @ kb lagate h
9:19 how to lock in laptop ?? F4 is not working
Use Fn+ F4 ✅
❤❤❤ 🙏🙏
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 Mujhe Hospital Billing Ke Liye Excel men automictic billing software banana hai uske liye men kese excel template bana sakta hon sir help me
Sir, Attendance sheet me Sunday ki tarah month ke 2nd aur 4th Saturday ki cell ko lock karna hai to kaise hoga
Attendance sheet ke videos dekho aap humare.. bataya hai unme ✅
sir training file is not working
thanks to inform.. but *its working...* i checked it..
download this file and go to your system download folder and click on this file to open it ✅✅
SIR ye jo VLOOKUP HACK formula hai wo wala kam nhi kr rha only single cell mein hi ata hai data so please tell me solution
Aap excel ka old version use kar rhe hain isliye aisa ho raha h g
@@DeepakEduWorld yes sir but sir ye formula old version mein kam nahi krega
Sum aur trim function not working, other functions is ok. Ple help me about sum and trem vlookup❤
To sum with vlookup Try to press ctrl shift enter and trim is very basic formula we just used it to remove extra spaces from data..
@@DeepakEduWorld u r great anna all v lookup working thanks anna ❤️
Monitor 2 times aaya hai leking quantity first wala hi pick kyo kiya ise to add karke dikhana chahiye tha?
Sir ye vlookup+ columns dusri work book se lgane pr work nhi kr rha h pahla record de rha baki sbme n/a aa ja rha h
Lookup value vala cell lock kro and table range b lock kro… columns formula m jo range di h uska pahele cell b lock kro✅✅✅
Jo 9 number ki sheet ka vloolup h usme formula enter karne k bad sare results tho aa ni rhe
VLOOKUP+SUM , Not working
Yr x look jub use kar sakh thy to v look q kar rahy x look up pay bnio master class
th-cam.com/video/0LjfRVD7srU/w-d-xo.htmlsi=czZredUlYq4AEMyk XLOOKUP FORMULA
th-cam.com/video/sPVl7_yVjLU/w-d-xo.htmlsi=SzmQSfet7ihZUSZC XLOOKUP
Sir, vlookup9 formula not working
vote for HLOOKUP
What about Xlookup 😂
SIR 9 NO VLOOKUP HACK WORK NAHI KAR RAHA HAI
Aap excel ka old version use kar rhe hain isliye..
th-cam.com/users/shortsNx--_KM0zJs?si=pmQrt5dxrK7iiJ61
M Excel 2010 use Karta hu.
Try this
First select the area in which you want to get value from vlookup.
Press Ctrl + Shift + Enter instead of enter.
Sir plz give your number to join your classes...
Sir please share your contact number
Nice