I'm trying to do multiple in my file from last 1 month , but bhooht try kiya ho nahi paya, jab ye video dekhi ,it's hardly take only 30 mints to me to create report auto ❤️❤️
thank you for quick responce,but what I asked you those answer is not into that video link , but I solve that means I already get all value by double vlookup. thank you again because I learn all from Watching your video You are good trainer, I learn lot of from You.
Sir Really Excellent and time saving Topic सर इस विडियों ने तो मेरी जो बहुत बडी समस्या थी उस समस्या को हि इस विडियों ने खतम कर दिया सर मे प्रा . ली कंपनी मे परचेस मे हु और मेरे से कइ बार परचेस ऑर्डर मे रेट लगाने मे गलती हो जाती थी जैसे की Product type - Pearl Location - Ahmedabad Rate - 80 Product Type- Pearl Location- Surat Rate - 81 Product Type - Pearl Location- Baroda Rate - 82 ऐसी और बहुत सारी मल्टी प्रोडक्ट है और समस्या ये थी की इन सभी प्रोडक्ट का सप्लायर ऐक ही कंपनी करती है जो इन अलग अलग जगह से प्रोडक्ट भेजता है Sir again Specially Thanks for this video
Thank you bro you made my day I was on a project and strucked and was browsing for this problem since yester day all the time i was recommended with same simple Vlook function and now i saw you video it oversimplified my problem. Thank you very much Brother!!!!!!
Yeah nice technique. If u want a method other than the helper column method and that without it, visit my must watch th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Sir, I am waqar ahmed from pakistan karachi city distric Malir, I look a lot of videos "Deepak Edworld" your make understanding style very good and easy for student ............
Thank you so much sir Mujhe Apne office report me ek problem face ho rha h ki 2 cell ko add krne ke liye mujhe / ka use kena h lekin mujhe ye chahiye ki agar 2nd cell blank ho to" /" Na aaye aisa koi rasta ho to please mujhe suggest kren Thank you sir
Sir very nice video I'm very interested in learning the excel hidden secrets like working in VBA and advance formulas as I'm experimenting daily on new formats and I want to know that if is it possible to use vlookup for searching the particular entry in data table and if it is founded then that entry must be highlight with a particular color Thanks in advance for your suggestions Jai hind
U can achieve this even without vlookup by simple match function if a=b statement. Watch this on this channel. th-cam.com/video/UtlYkQCG3uk/w-d-xo.html Mail ur query to simransimmykaur124@gmail.com If problem still persists
To us cell ko bhi helper column me concatenate karna padega. Vlookup doesn't posses this feature natively but u can still achieve this and even without helper column with array method..Watch this th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Is it possible to create dependent Vlookup...? I mean, agar ham kisi cell me koi value put Karen to uske dependent / respective range or Sheet se value pick kare....
Sir koi aisa vedion banaiye jisme vlookup ke sath sum krna ho aur condition ye h ke mere pas large data h mtlb 100 se zyada row ya column me sum krna ho to kaise kr sakte h . Plssss sir help me urgently
Hello sir, This vedio is very helpful. But I need to find the data from the vlookup value in a single column . Like we have to know some students name And other students roll number And some other Regd no remember I need to find the data in these criteria Kch ka roll number pta h to roll number se find kr le Jiska Regd number pta h uske Regd number se find kr le Is trh ka koi update ho aapke pass uspe vedio share kariye sir
Same technique. Concatenate 3 columns in helper. But this can be achieved without helper column also with an array formula. th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Hello sir, I have questions. I have create a category drop down list by text And in another cell I need sub names from category by selecting When I click sub name they show me 3 cell data under another down cell which I want to lookup will it possible? Example: 1.baby budget, 2.hospital bag(category) Under another cell sub name 1."milk, nurse, doctor" 2. Doctor, room cost, bad cost" When I click sub name like doctor they show me total cost( from another selected cells sheet) of doctor.
Vlookup Full Tutorial Basic to Advanced
th-cam.com/video/V4YgQTFLmyc/w-d-xo.html
I'm trying to do multiple in my file from last 1 month , but bhooht try kiya ho nahi paya, jab ye video dekhi ,it's hardly take only 30 mints to me to create report auto ❤️❤️
thank you for quick responce,but what I asked you those answer is not into that video link , but I solve that means I already get all value by double vlookup. thank you again because I learn all from Watching your video You are good trainer, I learn lot of from You.
I have tried what I want and I get the result after using concepts of your video.
Thank you so much.
Sukriya Sir ji
Thank you so much sir bahut dino se ye video khoj rha tha finally aaj mil gya Thank a lot sir ji
Sahib! aap bahuti achitharah samjaren hai. Apko salaam
Yeah really. Keep learning. A must watch recommendation from my side.
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Awasome bhai, appko nhi pata isne mera kaam bahut aasan kar diya.. Thanks a lot!!
]
Sir Really Excellent and time saving Topic
सर इस विडियों ने तो मेरी जो बहुत बडी समस्या थी उस समस्या को हि इस विडियों ने खतम कर दिया
सर मे प्रा . ली कंपनी मे परचेस मे हु और मेरे से कइ बार परचेस ऑर्डर मे रेट लगाने मे गलती हो जाती थी जैसे की
Product type - Pearl
Location - Ahmedabad
Rate - 80
Product Type- Pearl
Location- Surat
Rate - 81
Product Type - Pearl
Location- Baroda
Rate - 82
ऐसी और बहुत सारी मल्टी प्रोडक्ट है और समस्या ये थी की इन सभी प्रोडक्ट का सप्लायर ऐक ही कंपनी करती है जो इन अलग अलग जगह से प्रोडक्ट भेजता है
Sir again Specially Thanks for this video
Thank you sir, multiple criterian vlookup bohat see teachers see seekha but ho Maza aap ki video se Mila woh aaj Tak kahi nahin mila
Thank you bro you made my day I was on a project and strucked and was browsing for this problem since yester day all the time i was recommended with same simple Vlook function and now i saw you video it oversimplified my problem. Thank you very much Brother!!!!!!
Nice video, every video new new things to know
Nice explanation...... any one can easily understand
Thank u sir ji
Yeah nice technique. If u want a method other than the helper column method and that without it, visit my must watch
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Aapka padane ka tarika bohot accha he sir 🙏🏻
you are great sir
आप की videos हमेशा interesting होती हैं।
Sir, I am waqar ahmed from pakistan karachi city distric Malir, I look a lot of videos "Deepak Edworld" your make understanding style very good and easy for student ............
Thank u boss....bahut kam ka formula he....
Very nice superb style of teaching Sir ...🙏🏻👌🏻
Very Nice Trick for same or common Values
Very helpful. Neatly explained
Thnks a lot. Finally I understand the concept and applied successfully. 🙏🏻🙏🏻🙏🏻
Golden video 👍❤️
Apke sabhi videos dekhte ha ❤❤❤
Very very useful ..thankyou sir
Love to watch your videos..
Very nice. Keep it up thanks.
Very good video, Clearly defined function thanks sir.
Wah bhai Wah maza Aa gaya
Sir yours way is too simple too perfect
Thanks for this type video & helful
Very helpful 👍
Good bhai ❤
Thank you sir ji
kya baat he baiya kya baat he
Good Video. Informative. Thanks.
Thanks 😊, very nice
dipak sir very good vlookup formula
ultimate video for excel learning....
very help full
😊
Sir ye process acha hai but Sir aapki ek video maine dekhi hai jisme aap ek he bar main multiple values nikalna sikhaya tha
Thankyou Sir
this file (formula) is very help full for CA also, to reconcile GSTR-2
You great Sir ji useful Tips
Great..
😊
Apki saree videos helpful hai 👍
Awesome thanks sir
Thank u air !!!!!!
Thank you ❤
Good video sirji
Excellent
Informative video sir..
super sir, put more videos
🤗😊
nice vdo.............
I can also use there Count Ifs formula...
Sir ek video aisi bana do isme bhot sare naam ho or humne sirf jinka naam A se start ho us pe if function lagana ho kese lagayege.. 🙏
Thank you so much sir
Mujhe Apne office report me ek problem face ho rha h ki
2 cell ko add krne ke liye mujhe / ka use kena h lekin mujhe ye chahiye ki agar 2nd cell blank ho to" /" Na aaye aisa koi rasta ho to please mujhe suggest kren
Thank you sir
Great Sir. Regards
Pradeep
Thanks🙏
excellent sir g
Great but incase if in data father name or column D is not there ..eg i want final result like Ajay 455/458..is it possible
Sis,ji,apke.video,to.best.par.ak.probleam.ap.apne video.ko.jum.nahe.karte.hame.farmule.dekhte.nahi.to.plese.jum,video.bataya.karo..
G
Yar deepak sir hospital ke leye bhi much example video do na plz
Kuch video do na plz. Thank u.
Nice video Sir. Please publish a video about SAP.
In table formate how to use two time vlookup formula otherwise another formula, please reply
nice sir
isi prakar multiple lookup value se countifs karne ke liye video banaye
sach me maja aajayega
G
to kb publish ho raha he video?
deepakji vloocup se even column ya odd column se data uthana he to kese kare jab multiple column s ho
Sir very nice video
I'm very interested in learning the excel hidden secrets like working in VBA and advance formulas as I'm experimenting daily on new formats and I want to know that if is it possible to use vlookup for searching the particular entry in data table and if it is founded then that entry must be highlight with a particular color
Thanks in advance for your suggestions
Jai hind
We have to use vlookup with conditional formatting.. 👍.. Welll wait i ll publish video as soon as possible 👍
U can achieve this even without vlookup by simple match function if a=b statement.
Watch this on this channel.
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Mail ur query to simransimmykaur124@gmail.com
If problem still persists
how to extract all data by double or triple vlookup , pls make video as soon as possible
Thank you so much.
Nice truck.
good explanation.
Hi deepak
Aapke videos bahut dekhti hu. Very useful videos.
Merit ek problem sort out kr do pls.
Yes tell me.. How may i help you?
Sir construction company ka expenses report Excel me kaise maintain kare plz bataye
Kya Vlookup aur IF functions ko combination me use kr sakte hain...?
Please share an example how it is possible.
Thankful videos
Thanks sir
👍👍👌👌💗💓😛💛😲😜😍💟😧💚💕💞💝💘💘
Agar muje reetu aur nidhi and etc ek sath muje unke information check karke extract karna ho tho kaise karenge.... please respond
To us cell ko bhi helper column me concatenate karna padega. Vlookup doesn't posses this feature natively but u can still achieve this and even without helper column with array method..Watch this
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Wow
😊
Thanks
Best
mujhe multiple vlookup main ek product ko define karne lekin multiple coloum se..kaise karu..
good
😊😊
good job
sir to phir faida kia hai k hm jb extra colum banaty hai
U can do this without helper column also by array technique.
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Very nice Sir.
Mujhe aur achha video TH-cam per send karo sir Excel ka
Good morning sir
Agar father name na ho aur ek he list mein 3 ajay ya nidhi ho toh kaise aega result?
This is a case of multiple match. Refer to this.
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Thanks sir
very helpful
Awesome
Gjb sir thoda Hlookup aisa bta dete
apka insitute kha h sir
⚡⚡🤟🎉👏
sir ek cell me lookup kitne bar lga sakte hai
As many times as u require.
U can even achieve multiple lookup without helper by array method.
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Good morning sir,
Kya isme ek hi jaga se multiple destination ka detail nikal sakta hu or countif formula add kar ke
th-cam.com/video/k4-JyA6qruo/w-d-xo.html
Nice sir
Is it possible to create dependent Vlookup...?
I mean, agar ham kisi cell me koi value put Karen to uske dependent / respective range or Sheet se value pick kare....
Sir, how to get this result without helper column? is it possible
Hlw sir monthly sale and purchase inventory kese maintain kre format share kre pura Monty include ho jaye
I ll publish video as soon as possible
Sir koi aisa vedion banaiye jisme vlookup ke sath sum krna ho aur condition ye h ke mere pas large data h mtlb 100 se zyada row ya column me sum krna ho to kaise kr sakte h . Plssss sir help me urgently
This method is not working from me. Why?
Sir jis tara ya table bana howa ha is table ko koi code ya number da kar vlook up ya excel ma kasay sat karsaty han please video bana dan
Hello sir,
This vedio is very helpful. But I need to find the data from the vlookup value in a single column .
Like we have to know some students name
And other students roll number
And some other Regd no remember
I need to find the data in these criteria
Kch ka roll number pta h to roll number se find kr le
Jiska Regd number pta h uske Regd number se find kr le
Is trh ka koi update ho aapke pass uspe vedio share kariye sir
Sir 3 coloum ko kese vlookup kare
Same technique. Concatenate 3 columns in helper. But this can be achieved without helper column also with an array formula.
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Vlookup se sare column ki value ek hi cell main dikha sakte hain
Hello sir, I have questions.
I have create a category drop down list by text
And in another cell I need sub names from category by selecting
When I click sub name they show me 3 cell data under another down cell which I want to lookup will it possible?
Example: 1.baby budget, 2.hospital bag(category)
Under another cell sub name 1."milk, nurse, doctor" 2. Doctor, room cost, bad cost"
When I click sub name like doctor they show me total cost( from another selected cells sheet) of doctor.
Thank you very much, The second formulae is not working =VLOOKUP(C19&"/"&B2:H11,7,0), this is not working , I put the same data, please suggest me
&"space/space"&
Lolup value has not been properly concatenated.
Can refer to this video as well
th-cam.com/video/UtlYkQCG3uk/w-d-xo.html
Sir excel to aap ka lagbab h hi.
But ms word ko vi complit kr dijiye. Plz......