Dear my trainer Good help and very nice your u tube presentation any solution of provided by you in this presentation very easily know by other and it's help to new users it lean computer v lookup formula.thanks
deepak bhai thank you very much i learnt too many new formulas and other things can you make a video that regarding daily sales sheet and individual item sheet i mean if i enter in daily sheet different items then it should be automatically display in individual time sheet and automatically the stack which i sold it will deduct and display the closing stock balance please try to do this thank you once again for your tutorial
Superb video sir Sir plz make a video to calculate any days between two dates .For example I want to find out Sundays between 01/04/2016 to 31/03/2107 so which formula I use to find out Sundays , Mondays friday etc days . Sir can I use networkdays Intl formula in 2007 excel and how .?
Hello Deepak,You are doing a good job. Please advise how we can find a value in a table using dependent vlookup value. For example if want to find out how many students, boys, girls,.....in class9th. now result should depend on section 9th or 8th A,B,C or D in one table. We have two selection in one table #1 is Class and second is section. we are using two drop downs one for class and second for section in vlookup. Also how can we format drop down menu. Like if we want to change font or text color in drop down menu. if you want I can forward a sample table to understand better Thanks
Sir g MIS par video banaya hai Kya apne.. aur Mai ye Janna chahta hu ki ye sab videos jo apne bnaye hai mtlb total advance Excel na.. please bataiye ... Muze idea nahi hai isliye puch raha hu.. please sir.
Dear bhaiya if we have a name of another workbook sheet then beside selecting the whole table can we write name on it please tell me about this dear bhaiya 👍👍
Sir vlookup ka table array jab dusre excel se link karte hai fir donk excel close karke formula Wala sheet open karte hai to vlookup formula me error bataya hai, fir jab dono sheet open hota hai to correct hota hai
Deepak EduWorld Sir I want create student marksheet. All data are in different workbook I want fetch only desire data from this workbooks for example exam marks. And make capy of thses marksheet or progress report of all stodents. So which method I have to use? Please guide me. And thanks a lot to reply me
Sir ji date ke anusaar vlookup bataye jese school me admissions date 01/07/20 to student school,sc,st,obc,sbc,gen, ke student boy and girls ko lookup velue sekese check kare please help
Deepak ji can we validate cell or range of cell for entering unique number with specific length no text and not more than 10,11digits if yes please make a video Thanks
Sir Ji ...... Can you make currency exchange rate to web notification in direct by excel sheet...... Like Rupees, USD.... Or other With word . Can you make this deskboard..... I have big Request...........
Multiple workbook me vlookup ka formula multiple value k liye kya h. Abhi aapne bataya single k liye bataya. 1 cell me farmula lagane se sab coloum me ans aaye. Single workbook me hum columns farmula laga k kr saktr h but 2 workbook me vo farmula kam nhi karta h. Plz advise.
Dear Sir Agar hum Vlookup formula main ksi pacific name ko search kare tu kase kare ge for example (Mr, Imran) hame is name ko search karna ha k Mr. Imran Ne Start Date 1/01/2019 and End Date 31/01/2019 Tak kitne incom jernate ki ha, kya asa koi formula ha ?
Vlookup Full Tutorial
ruclips.net/video/V4YgQTFLmyc/видео.html
Sir aap kitne ache se aur pyar se samajate ho best of luck sir ji
Thank You Deepak Sir, for this Wonderful & important Video about "V LOOK UP"🙏
Very nice sir you are great 🙏🙏🙏🙏
I'm your's daily viewer.your teaching style is totally an amazing.thank you.
sir the way you teach us the excel no one has ever taught that before,great work sir
You are such a brilliant excell master. Very easy, very Informative. Good job Deepak. Love from Pakistan 🇵🇰🇵🇰
Thanq sir, really helpful 🙏
VERY HELPFUL VIDEO
THANKS SIR G
sir, your all videos are good and easy to learn.
sir maine formula taskbar se workbook switch kar k lgaya tha and it's working.
Great classes, thank you
Wow. Best Excel formula
Very informative thank you 👍
Fantastic.. Excellent & Helpful.... Thanks
Sir this video is soo much useful, and very clear explanation. thankyou soo much.
Wow very good
Very good sir
Fantastic... Thank you Sir
Your learning method is superb,,😀😀👌✌️👍👍👏👏🙏
Very nice thanks this is what I was searching...👍👍😊
Happy teachers day sir thanks for your very helpful videos
Thank you g 😊
Nice sir good method to learn
, 😊
Vlookup to apne aap me kamal ka h hi par ye IFERROR aur bhi badhiya h 1st time hum dekhe h IFERROR ka use.
excellent video Deepakji, thanks
lovely sir
Excellent
Thank you so much sir 💐🙏
Good Job Deepak sir
very informative video sir
Very useful for me, thanks
WE NEED MORE EXCELLENT VIDEO LIKE THIS BROTHER
🤗🤗
Excellent idea bro...thank u so much...
Very nice 💐
Good work...very helpful...
Very informatative
very nice
Good job sir
NICE AND THANKS SIR G
AWESOME VIDEO, KEEP IT UP.
Helpful ।।।
Awesome sirji keep up d good work :)
Super
thank u sir so much
I always watch your video sir.. Your explanation is awesome.. Keep up the good work. :)
Thanks Sir G Nice Video
Nice video sir
Nice sir
Dear my trainer
Good help and very nice your u tube presentation any solution of provided by you in this presentation very easily know by other and it's help to new users it lean computer v lookup formula.thanks
Nice✌🏻
thank you sir
Ye video mst h sir
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Dates ke anusar vlookup bataye
Bro.. can we apply this formula for online sharepoint workbook rather than desktop workbook ?
deepak bhai thank you very much i learnt too many new formulas and other things
can you make a video that regarding daily sales sheet and individual item sheet i mean if i enter in daily sheet different items then it should be automatically display in individual time sheet and automatically the stack which i sold it will deduct and display the closing stock balance please try to do this thank you once again for your tutorial
Likky Devendher i want also like this.
+Likky Devendher ok g
thank you
😊
SK SAHAJAHAN vxxx
Jabardast
Sach bolu is baar sir ji apne chhoti chiz lambi kar ke paka diya plz ise achhi technique se badal de
Mast
Deepak eduworld keep sare vedio best hair. But I want to short data in another sheet by selecting drop-down list. Yeah problems solve Karo sir.
Sir if we add more data in payslip sheet ,can vlookup sheet update automatically. Please reply
Alt + tab ka use karke other sheet per bhi ja saktey h
Hello sir my self pratap from odisha
I have some problems in Excel vlookup formula
Please help me sir
Superb video sir
Sir plz make a video to calculate any days between two dates .For example I want to find out Sundays between 01/04/2016 to 31/03/2107 so which formula I use to find out Sundays , Mondays friday etc days .
Sir can I use networkdays Intl formula in 2007 excel and how .?
+MD AFTAB ALAM ok i will publish video as soon as possible
alt+tab se nhi ja skte kya dusri table pr
Hello Deepak,You are doing a good job. Please advise how we can find a value in a table using dependent vlookup value. For example if want to find out how many students, boys, girls,.....in class9th. now result should depend on section 9th or 8th A,B,C or D in one table. We have two selection in one table #1 is Class and second is section. we are using two drop downs one for class and second for section in vlookup.
Also how can we format drop down menu. Like if we want to change font or text color in drop down menu. if you want I can forward a sample table to understand better
Thanks
nice video sir esi trh se hlookup ka be bta do or lookup ka
+Sanjay Rawat ok g
Sir g MIS par video banaya hai Kya apne.. aur Mai ye Janna chahta hu ki ye sab videos jo apne bnaye hai mtlb total advance Excel na.. please bataiye ... Muze idea nahi hai isliye puch raha hu.. please sir.
Sir i request you to make videos on each ribbon tab.
Dear bhaiya if we have a name of another workbook sheet then beside selecting the whole table can we write name on it please tell me about this dear bhaiya 👍👍
kya hum multiple workbook me multiple vlookup use kar sakte hai
Sir vlookup ka table array jab dusre excel se link karte hai fir donk excel close karke formula Wala sheet open karte hai to vlookup formula me error bataya hai, fir jab dono sheet open hota hai to correct hota hai
Hii DeepaK sir. Please tel me how to copy data from excel work book which is generated by using formulas
+Ankush Supnar u wanna.. Copy data automatically.. Into another workbook??
Deepak EduWorld
Sir I want create student marksheet. All data are in different workbook I want fetch only desire data from this workbooks for example exam marks. And make capy of thses marksheet or progress report of all stodents. So which method I have to use? Please guide me.
And thanks a lot to reply me
sir agar 4 ya zada worksheets hon to bhi same treeka he array select krne ka
Yo
Video Qualities to achha rakha kro.
Sir how are you I hope you recover from health . pls guide me how to vlookup in 2007 version in multiple sheet
I am fine now... Please visit our formulas playlist..
सर vlookup में table array के 2nd कॉलम को base मानकर data find करनी है। तो उसके लिए क्या करें। जनरली vlookup में 1st कॉलम से डाटा find होती है।
Isme switch window whi se krna hoga.. Jb hum table select krenge.... Alt tab use nhi kr skte... Table select krte waqt
Ys
Does vlookup works when 'lookup value ' is repeating multiple times in the selected array ?
ruclips.net/video/MUmsiEFY7us/видео.html
Sir ji date ke anusaar vlookup bataye jese school me admissions date 01/07/20 to student school,sc,st,obc,sbc,gen, ke student boy and girls ko lookup velue sekese check kare please help
Multiple sheet mein alag alag data ho to X lookup kaise lagega
Ram ram nehra sahab
🤗🤗🤗🤗😊 😊
Deepak ji can we validate cell or range of cell for entering unique number with specific length no text and not more than 10,11digits if yes please make a video
Thanks
Please watch this video link is ruclips.net/video/ZTlymO0uug4/видео.html
sir agar hame another workbook se drop down banana ho to kya ye possible hai kya?
Ys
ruclips.net/video/-IDqfwby5MM/видео.html
Sir yadi 1 workbook me 4 sheets me alag alag data hai to usko kese ek formula me use karenge
Sir, vlook excel sheet ya dynamic excel sheet ko agr email krna ho to kaise krenge.......? kyuki jb mail krte h to blank sheet mail hoti h.....
Sir Index with Match function ke aur videod publish kijiye
Ok g
Bhai short cut keys bhi batya karo pls
After closing the payslip workbook vlookup not working in excel2007..
Sir please guide
Cntrl +tab SE bhi dusre file pe jaa sakte hain
Alt + Tab
Sir,
Men vlookup formula use ker raha hun kisi dusri sheet se us sheet men already formulas lage huwe to vlookup kaam ni ker raha... plz help
How to use this with dynemic multiple workbook
Sir jo pay slip aur vlookup ka swich banaye h usi me hame daut lag raha h
Sir Ji ......
Can you make currency exchange rate to web notification in direct by excel sheet......
Like Rupees, USD.... Or other
With word .
Can you make this deskboard.....
I have big Request...........
I fallow your idea but it does not work in my excel file. Values can't be seen when one file is closed.hope right suggestions from you .
Single date me do data raw hai to vlookup keise lagayenge.?
Please reply
sir can u also teach us python and SQL
Multiple workbook me vlookup ka formula multiple value k liye kya h. Abhi aapne bataya single k liye bataya. 1 cell me farmula lagane se sab coloum me ans aaye. Single workbook me hum columns farmula laga k kr saktr h but 2 workbook me vo farmula kam nhi karta h. Plz advise.
iserror and iferror dono ko kab or kis conditions m use krni h data k sath ek bar explained kr De to it will be greatful
+Sharma Excel VBA And SQL Classes ok ji i will compare both formulas... Publish video as soon as possible
plz assist me difference between iserror and iferror in which cond use iferror and iserror plz give me help
+Sharma Excel VBA And SQL Classes iserror says true and false.... If error in formula thn iserror return true otherwise return false
plz assist me with practical use then I can better understanding
Dear Sir
Agar hum Vlookup formula main ksi pacific name ko search kare tu kase kare ge for example (Mr, Imran) hame is name ko search karna ha k Mr. Imran Ne Start Date 1/01/2019 and End Date 31/01/2019 Tak kitne incom jernate ki ha,
kya asa koi formula ha ?
Nixe question.. I ll publish video shortly.. Please wait