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.
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☺
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.
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](http://i.ytimg.com/vi/KJ8jFCsZB2Y/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
❤
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..
Bahut hi acha video banae hai sir aap really very understandable thankyou so much
Bohot accha video hai ❤❤❤❤🎉🎉❤❤
sir g ap ne sirf asi 1 video pr meri sb se bari problems solve kr di dynamic vlook k through . thanks a lot
ua-cam.com/users/shortsNx--_KM0zJs?si=pmQrt5dxrK7iiJ61
Best video for who want to learn Vlookup in advance level.👏
Very useful
Awesome video sir... thanku...🎉
YOUR TEACHING STYLE IS AMAZING SIR, TAUGHT MANY COCEPTS ONLY IN 35 MINUTES WITHOUT WASTING TIME IS INCREDIBLE EFFORT BY YOU.
THANKYOU
Perfect video for v lookup who wants to learn
Thank you very much sir
Very very helpful video 🎉🎉🎉🎉🎉
20:04 and 26:17
A very informative video. Thanks for sharing such a precious knowledge.
Sir aise hi index and match ka bhi full tutorial bana dijiye.. plus (index+match)
Mai kab se vlookup ki advance video khoj rha tha. Finally i found it.
एक ऐसा sheet जिसपर weekly, monthly, quarterly, half yearly तक का एक क्लिक पर किस्त निकल जाए। 🎉
Bahot accha laga
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!
Top notch explanation 👌
Sare hi bdiya the bhai ji
wonderful tutorial dost. aage bhi aise videos banate rahen... speciallly Array concept ke upar
Fruitful sirji🙏🙏🙏
Awesome sir g❤❤❤
Excellent Sir,
Mujhe vaise to Puri video hi bahut pasand aai lekin jo aapne choose formula lagaya vo bahut bahut mast laga.
Thanks g 😊
Thank you so much for this wonderful tutorial Sir❤🙏
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.
Very informative video❤
I learned a lot from you
Thank you sir
Boss tussi grate ho awesome Jai hind sir Deepak Lucknow ❤❤
ua-cam.com/users/shortsNx--_KM0zJs?si=pmQrt5dxrK7iiJ61
I really enjoy this video really help to me
All are superb
So helpful, Thank you so much.
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.
Thank you sir ji ❤
columns lage k liye colums uper hi select karna hoga
Welcome
❤❤❤❤ 🔥🔥🔥🔥🔥🔥
Sir (vlookup+match) vs (index+match) konsa best hain....?
Thankful❤❤❤
Great
Nice Sir
Thanks bro❤❤❤❤❤❤❤
Vlookup 3 sheet mein hlookup sahi ya jo aapne bataya vlookup wo?
Perfect video
Nice
👌
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
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.
Choose and column
Amazing video sir but mera curly bars function work ni kr rha h koi bta skta h kyu?
Sir can we use it in our portfolio? For freelancing.
Yes.. definitely you can use it if required ✅
@@DeepakEduWorld thanks
Monitor 2 times aaya hai leking quantity first wala hi pick kyo kiya ise to add karke dikhana chahiye tha?
Practice file
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 vlookup ke saath @ kb lagate h
❤❤❤ 🙏🙏
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
choose
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 ✅
9:19 how to lock in laptop ?? F4 is not working
Use Fn+ F4 ✅
Jo 9 number ki sheet ka vloolup h usme formula enter karne k bad sare results tho aa ni rhe
VLOOKUP+SUM , Not working
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 ❤️
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✅✅✅
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
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, vlookup9 formula not working
vote for HLOOKUP
What about Xlookup 😂
Yr x look jub use kar sakh thy to v look q kar rahy x look up pay bnio master class
ua-cam.com/video/0LjfRVD7srU/v-deo.htmlsi=czZredUlYq4AEMyk XLOOKUP FORMULA
ua-cam.com/video/sPVl7_yVjLU/v-deo.htmlsi=SzmQSfet7ihZUSZC XLOOKUP
SIR 9 NO VLOOKUP HACK WORK NAHI KAR RAHA HAI
Aap excel ka old version use kar rhe hain isliye..
ua-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