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.
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!!!!!!
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 ............
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
Yeah nice technique. If u want a method other than the helper column method and that without it, visit my must watch ruclips.net/video/UtlYkQCG3uk/видео.html
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. ruclips.net/video/UtlYkQCG3uk/видео.html Mail ur query to simransimmykaur124@gmail.com If problem still persists
Excellent. But sir kaya is ka just ulta v ho sakta hay ?? Jsyse may sirf student ka name dunga or instantly us studend ka Father ka name & roll no & marks v automatically ya jayga ?? Kindly try it n post the new video. I shall wait for your next video. Thnx again Sir.
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
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....
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.
Sir, I have 5 accounts (Eaxm-A, B, C, D, E), they have separate sheet entries, I want to see the account of any month, any day of those 5 accounts (Exm- Deposit, Withdrawn & Interest) . Which will show in a separate sheet 5 Accounts together. How can I see with the help of Vlookup or any other formula?
Sir maine ek report card ready kiya h usme alag alag sheet p unit wise marks h mai chahta hu ki usme ek look-up se saare marks report card ki sheet m subject wise aa jaye
aisa formula bataye sir ki Student name or father name mein koi bhi ek name put karne mein marks obtained aa jaaye. I mean to say ekformula aisa bataye ki dono mein se jo bhi put kare detail aa jaaye
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
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 ruclips.net/video/UtlYkQCG3uk/видео.html
Hello! Thanks for this video and i have learnt many things from you, now i have a problem with large data so can you help me to fix this My data like below A=1,2,3 again 1=x or y. 2=x or y 3=x or y i have to look up if A=1 then 1=x or y A=2 then 2=x or y. can you help me about above info?
Mr. deepak ji.. mujhe sirf kisi ek part ki 2 times name entry krni hai . but unke order no. or date different different hai. mere pas mater list hai..but working sheet me unki entry me kafi gape hai..to dono ke order kaise alg alg aayenge.. or me part no. bhi changr nhi kr skta. please isko lekar koi video bnao.
Helper column actually tells u about the steps taking place . However by array method u can achieve the same without helper column. Watch this ruclips.net/video/UtlYkQCG3uk/видео.html
How to make helper cloumn when data is save is separate row and column example: Stu name data are saved in column and Father Name Data are saved in rows
Vlookup Full Tutorial Basic to Advanced
ruclips.net/video/V4YgQTFLmyc/видео.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.
ruclips.net/video/UtlYkQCG3uk/видео.html
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!!!!!!
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 ............
Aapka padane ka tarika bohot accha he sir 🙏🏻
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
Awasome bhai, appko nhi pata isne mera kaam bahut aasan kar diya.. Thanks a lot!!
]
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
ruclips.net/video/UtlYkQCG3uk/видео.html
Thank u boss....bahut kam ka formula he....
आप की videos हमेशा interesting होती हैं।
you are great sir
Very Nice Trick for same or common Values
Thnks a lot. Finally I understand the concept and applied successfully. 🙏🏻🙏🏻🙏🏻
Very nice superb style of teaching Sir ...🙏🏻👌🏻
Very helpful. Neatly explained
Apke sabhi videos dekhte ha ❤❤❤
Sir yours way is too simple too perfect
Very very useful ..thankyou sir
Sir ye process acha hai but Sir aapki ek video maine dekhi hai jisme aap ek he bar main multiple values nikalna sikhaya tha
Very good video, Clearly defined function thanks sir.
Thanks for this type video & helful
dipak sir very good vlookup formula
Very nice. Keep it up thanks.
Wah bhai Wah maza Aa gaya
Golden video 👍❤️
Love to watch your videos..
Good Video. Informative. Thanks.
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
Very helpful 👍
ultimate video for excel learning....
very help full
😊
Thank you sir ji
this file (formula) is very help full for CA also, to reconcile GSTR-2
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
Kya Vlookup aur IF functions ko combination me use kr sakte hain...?
Please share an example how it is possible.
kya baat he baiya kya baat he
You great Sir ji useful Tips
Thanks 😊, very nice
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
Mail ur query to simransimmykaur124@gmail.com
If problem still persists
super sir, put more videos
🤗😊
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.. 🙏
Excellent. But sir kaya is ka just ulta v ho sakta hay ?? Jsyse may sirf student ka name dunga or instantly us studend ka Father ka name & roll no & marks v automatically ya jayga ??
Kindly try it n post the new video.
I shall wait for your next video. Thnx again Sir.
I can also use there Count Ifs formula...
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
Apki saree videos helpful hai 👍
how to extract all data by double or triple vlookup , pls make video as soon as possible
Good bhai ❤
Awesome thanks sir
Great..
😊
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
Thankyou Sir
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
In table formate how to use two time vlookup formula otherwise another formula, please reply
Good video sirji
Excellent
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?
Thank u air !!!!!!
Yar deepak sir hospital ke leye bhi much example video do na plz
Kuch video do na plz. Thank u.
nice vdo.............
Informative video sir..
Great Sir. Regards
Pradeep
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....
excellent sir g
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.
Sir, I have 5 accounts (Eaxm-A, B, C, D, E), they have separate sheet entries, I want to see the account of any month, any day of those 5 accounts (Exm- Deposit, Withdrawn & Interest) . Which will show in a separate sheet 5 Accounts together. How can I see with the help of Vlookup or any other formula?
Thank you ❤
good explanation.
Vlookup se sare column ki value ek hi cell main dikha sakte hain
Sir maine ek report card ready kiya h usme alag alag sheet p unit wise marks h mai chahta hu ki usme ek look-up se saare marks report card ki sheet m subject wise aa jaye
Thank you so much.
Nice truck.
Nice video Sir. Please publish a video about SAP.
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
ruclips.net/video/UtlYkQCG3uk/видео.html
aisa formula bataye sir ki Student name or father name mein koi bhi ek name put karne mein marks obtained aa jaaye. I mean to say ekformula aisa bataye ki dono mein se jo bhi put kare detail aa jaaye
Kya isme ek hi jaga se multiple destination ka detail nikal sakta hu or countif formula add kar ke
ruclips.net/video/k4-JyA6qruo/видео.html
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
Good morning sir
Sir, how to get this result without helper column? is it possible
Thanks🙏
mujhe multiple vlookup main ek product ko define karne lekin multiple coloum se..kaise karu..
Sir construction company ka expenses report Excel me kaise maintain kare plz bataye
This method is not working from me. Why?
good
😊😊
good job
Good morning sir,
What if father’s name ke place per date of birth ho...will it still work ?
U can watch this.
ruclips.net/video/UtlYkQCG3uk/видео.html
Btw filters r better way to catch date data.
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
ruclips.net/video/UtlYkQCG3uk/видео.html
Gjb sir thoda Hlookup aisa bta dete
apka insitute kha h 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.
ruclips.net/video/UtlYkQCG3uk/видео.html
sir to phir faida kia hai k hm jb extra colum banaty hai
U can do this without helper column also by array technique.
ruclips.net/video/UtlYkQCG3uk/видео.html
bhai agar roll number se father name aur stu name ki value chahiye tho kya formula lagana padega
Vlookuo
Hello! Thanks for this video and i have learnt many things from you, now i have a problem with large data so can you help me to fix this
My data like below
A=1,2,3 again 1=x or y. 2=x or y 3=x or y
i have to look up if A=1 then 1=x or y A=2 then 2=x or y.
can you help me about above info?
Use if ..... Statement instead. Using vlookup with multiple lookup value can also help.
ruclips.net/video/UtlYkQCG3uk/видео.html
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
Mr. deepak ji..
mujhe sirf kisi ek part ki 2 times name entry krni hai . but unke order no. or date different different hai. mere pas mater list hai..but working sheet me unki entry me kafi gape hai..to dono ke order kaise alg alg aayenge..
or me part no. bhi changr nhi kr skta.
please isko lekar koi video bnao.
Ya sure.. as soon as possible 👍 as
Sir helper column ki kya jarurat hai ?
Helper column actually tells u about the steps taking place . However by array method u can achieve the same without helper column. Watch this
ruclips.net/video/UtlYkQCG3uk/видео.html
Thankful videos
Thanks sir
👍👍👌👌💗💓😛💛😲😜😍💟😧💚💕💞💝💘💘
How to make helper cloumn when data is save is separate row and column
example: Stu name data are saved in column and Father Name Data are saved in rows
Very nice Sir.
Mujhe aur achha video RUclips per send karo sir Excel ka
Wow
😊
👍