Hello Deepak, You are doing a great job !!!! I like your videos very much.... I have a suggestion for you.... It would be great if you can share practice file with us. So that we can download it and practice on same time while watching videos.
Hallo DEEPAK JI YOU ARE A GREAT TEACHER. YOUR TEACHING METHOD IS EXCELLENT, AND YOU LEAVE NO QUESTION OR QUERIES IN LEARNERS' MIND. I THINK MOST PEOPLE UNDERSTAND YOUR TEACHING. THANKS 🙏🙏
But double vlookup is not applicable if table 2 contain duplicate person name. suppose that person id 101 and 109 both person has same name then in table 2 how do it search the particular name of the employee. Plz suggest
Sir mari pass ek fill badi fill h usme jayda clint h mari ko her clint alge sheet benani h jo main sheet me work kartu hu jo clint sheet uska work use me automatica ho jay
Aslam-0-Alikum, Umed karta hon depak bhai ap kheiyat xy hon gye, Sir m Accountant Ki job karta hon aur m ap ki her video bht shoq aur achy se dekhta hon, bht helpful hain ap ki tamam videos, sir kindly koi "Purchase order" ka acha sa format wali videos upload karen, Thanks.
Nice video sir Double vlookup se sirf salary hi aa rhi hai name nhi aa rha hai agr name b show Krna chahe to first example sahi rhega I think double vlookup ka kuch khaas use smj nhi aaya sir because name or salary dono show krne h
Deepak ji mere 1 pc par =spellnumber formula kaam Kar Raha hai with office 2013 but office 2019 me ye kaam nahi Kar Raha Kya koi setting disabled hai? Any solution if you have I'm using your excel spellnumber file in both office version.
If suppose In name column have multiple value ( same name for multiple time) then how it's work. E.g. if I have a data for clothing with 1 style option same for size (s,m,l,xl) variant. So I want ean Code for STYLE option ABC against size M. What formula is for convenient? Please suggest
Sir data validation me list banayi Hui h lookup values ki agar hum usme koi galat I'd enter karte h Jo data h m nahi h to list usko enter hi nahi karne deti h error ata h uska koi solution h for practice only HAPPY DIWALI SIR 🎉🎉MY FATHER EXPIRED ON THIS DIWALI SO I AM SO SAD ON THIS OCCASION
If there is same name in the name box field than how we apply vlookup in the same field ? If there is Tow name like Rohit than how it will work ? Please suggest.
Sir I Have a Sheet of 150 Student Fee -Remaining- Fine Etc... and after Total i add a Link of Print Voucher. and all fee Voucher in Different 150 Sheet . I want these all voucher in One sheet with With Different Print Area. Just Click Link in front of Name and command for Print.... How is Possible?
Maan lo table 1 par two I'd main same name Hain... ( I'd 101- Aman & 103-Aman). Aishe main double vlookup formula use Karke Table 2 par same name par salary dhondh na possible Hain kya... Plz bataye
Sir When I use VLOOKUP Formula to Search a Student with Student ID Everything is show like Name , Father Name , Class , Fee , Remaining, Receive & Total But I Cant Be able to Show Link Address for Voucher Print
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
Vlookup Full Tutorial Basic to Advanced
ua-cam.com/video/V4YgQTFLmyc/v-deo.html
Sir Aapka samjhane ka tarika kafi acha h....mujhe ye ab easy lgne lga h yhi phle jab dusri site pr pdhta tha to kafi boring lgta tha...so thank you
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
THANKUUUUU YRRR BHAII PHLEE BAR MUJHEE SMJHA AYA BHUT DIN SE KR RHA THA AJJ KUXH SMJH AA GYAA
Great Video Sir, Samjhane ka tarika bhi Great, Thnx in Tons
Mujse double vloop poocha tha mai nahi bata paya tha thax for next interview
Sir aap bahut important bala video banate ho . Ty so much sir .
🤗
Sir aapka teaching ka tarika mast hai samjh mai aa jata hai jaldi
Deepak sir very nice vedio. Aapne sahi kaha aapne bahot hi achhi trh se smjhaya hai
DEEPAK BHAI VERY NICE VERY HELPFUL
Thanks for your kind information.
Good afternoon sir,
A very good explanation of nested loops. Keep it sir, for such good examples for easy learning. Thank you.
😊
Aapki video mujhe achhi lgti hi .Mai aapka pura video dekhta hu
Done great job thanks for this video
Thanks for the helpful video bro.
Hello Deepak, You are doing a great job !!!! I like your videos very much.... I have a suggestion for you.... It would be great if you can share practice file with us. So that we can download it and practice on same time while watching videos.
You explain in very simple way.. Thank you 🌹
Hallo DEEPAK JI YOU ARE A GREAT TEACHER. YOUR TEACHING METHOD IS EXCELLENT, AND YOU LEAVE NO QUESTION OR QUERIES IN LEARNERS' MIND. I THINK MOST PEOPLE UNDERSTAND YOUR TEACHING. THANKS 🙏🙏
Dear sir ji,
Your voice is lovable ❤️❤️
Great sir really👍
Excellent .....Sir you are a Good Teacher ...
Great👍
Great 👍👍👍👍👍
great video
Superb! Subscribed!!!
Great work brother.... thanks for givin such an excellent excel video hats of u sir.....
Tune try kiya kya...formula lagta h.kya..try kr fir tarif kr...mai ne try kiya nhi ho rha h...
🎉🎉
Thanks You sir
Meine seekh Liya vlook up😊
Very helpful vdo sir .......
Very good and more useful
Very nice sir
Excellent👌👌👌
I am your new subscriber 😊
Nice explaination
Thek hai ji, aa gya samjh
Thank you very much sir
In this video last trick is just osm
excellent work
thank you sir for sharing your valuable learning videos
Excellent Work
Thanks Sir
Deepak ji very perfect way in explaining the stuffs. I appreciate it. It helped me. Great job.
+Abhilash Tp thanks
Awesome sir
Interesting to know
it's very helpful for me
Great work dude..
Keep spreading
best ever explained
You are the best...
Can you upload video on speedometre in excel
Nice Sir Keep it Up...But Sir Add the Practice Sheet Also in video Description ..............................
Excellent
I like your channel.
But double vlookup is not applicable if table 2 contain duplicate person name. suppose that person id 101 and 109 both person has same name then in table 2 how do it search the particular name of the employee. Plz suggest
Great job sir...
Thanks for guid for vlookup bro
☺️
Nice video
We can directly copy the name column n enter is it important to write or make a separate table tht u made for e.g. id n name column
Very good
Sir mari pass ek fill badi fill h usme jayda clint h mari ko her clint alge sheet benani h jo main sheet me work kartu hu jo clint sheet uska work use me automatica ho jay
Super sir
Tnx sir😊
finally find out what I want
Exactly
1 no
Sir all formula step by step with examples
+mahendra kumar please visit special ADVANCED EXCEL FORMULAS PLAYLIST, From channel
Aslam-0-Alikum, Umed karta hon depak bhai ap kheiyat xy hon gye, Sir m Accountant Ki job karta hon aur m ap ki her video bht shoq aur achy se dekhta hon, bht helpful hain ap ki tamam videos, sir kindly koi "Purchase order" ka acha sa format wali videos upload karen, Thanks.
umer nawaz ... THANK you Very much..... I will publish video for this as soon as possible......
Deepak EduWorld Thanks a lot dear Sir.
Subscribed
Great
Dear sir
Make video about libre office excel
niceeee sir g
O to 1 vlookup se bhi kar sakte hai
nice sir
Thank you
Nice
Nice sir
👌
Sir, id to unique hai but agar do unique id pe name same hai to data sahi aayega ya galat
Thanks
Thank you sir
good
Nice video sir
Double vlookup se sirf salary hi aa rhi hai name nhi aa rha hai agr name b show Krna chahe to first example sahi rhega I think double vlookup ka kuch khaas use smj nhi aaya sir because name or salary dono show krne h
Double vloook ka use Apke Data ke upr depend hota hai ki data kaisa hai
Please publish this video
Sir aap bohot mote ho gye ho phle se 😁 sorry don't mind sir
एक या एक अधिक rows या cells में मर्ज के आगे row ya cell up down data को vlookup के द्वारा कैसे लाते है ।
Sir agar second table main same name ho to ? Sahi salary pick up nhi hogi
If two employees have the same name then this concept will work or not please reply.
Deepak sir Namaskar vlookup mein look value jab change karte hai to auto refresh nahi hota mujhe double click karna padta hai plz. Solution
Deepak ji mere 1 pc par =spellnumber formula kaam Kar Raha hai with office 2013 but office 2019 me ye kaam nahi Kar Raha Kya koi setting disabled hai? Any solution if you have I'm using your excel spellnumber file in both office version.
Sir hlookup & vlookup ke sath sum formula use karna sikha do..
If there are 2 same name in table 2 what will we do.. ?
Deepak jee..how to learn VB.. PLS CAN YOU MAKE TUTORIALS ON IT ..Thanks
Double lookup ka upayog kab karna padega? Jab 2 table me se information lene padta hain tab, sahi hain na?
If suppose In name column have multiple value ( same name for multiple time) then how it's work.
E.g. if I have a data for clothing with 1 style option same for size (s,m,l,xl) variant.
So I want ean Code for STYLE option ABC against size M. What formula is for convenient?
Please suggest
Deepak sir, how to use multiple vllookup to creat marksheet from column to rows?
Sir data validation me list banayi Hui h lookup values ki agar hum usme koi galat I'd enter karte h Jo data h m nahi h to list usko enter hi nahi karne deti h error ata h uska koi solution h for practice only HAPPY DIWALI SIR 🎉🎉MY FATHER EXPIRED ON THIS DIWALI SO I AM SO SAD ON THIS OCCASION
my computer institute
i NEED A VIDEO ON HOW TO TRANSFER DATA IN EXCEL TO TALLY-9
Sir, result table me highlight bhi hona chaiye,taaki bade table me jaldi se dekh paaye, vo kese karenge
Sir bt ye salary or ID , name ke box kese bnate h ?
If there is same name in the name box field than how we apply vlookup in the same field ? If there is Tow name like Rohit than how it will work ? Please suggest.
Sir I Have a Sheet of 150 Student Fee -Remaining- Fine Etc... and after Total i add a Link of Print Voucher. and all fee Voucher in Different 150 Sheet . I want these all voucher in One sheet with With Different Print Area. Just Click Link in front of Name and command for Print.... How is Possible?
Very nice question.. Well please wait i will publish video as soon as possible
सर स्कूल जनरल रजिस्टर से living srtifike कैसे तयार कर सकते है ये तरिका बताओ सर जी
+vilas more okay ji... I'll publish video as soon as possible
Not Found nhi likha raha hai same as per video formula set kia hai
सर नमस्ते,
जसे कॉलमधील शब्द / संख्या row मध्ये paste करता येते त्याप्रमाणे row मधील शब्द उभ्या कॉलममध्ये paste करता येते का ? ते कृपया सांगा.
Kindly explain if there are 2 or 3 persons with same name, what formula to be used here?
Varun Sharma but ID can't be same
Varun Sharma it will not work....this formula will pick first value
Maan lo table 1 par two I'd main same name Hain... ( I'd 101- Aman & 103-Aman). Aishe main double vlookup formula use Karke Table 2 par same name par salary dhondh na possible Hain kya... Plz bataye
How can we use vlookup and hlookup in a single Formula? Pls guide
Sir When I use VLOOKUP Formula to Search a Student with Student ID Everything is show like Name , Father Name , Class , Fee , Remaining, Receive & Total But I Cant Be able to Show Link Address for Voucher Print