Sir I do it but I face one problem when I copy to put formula & drag down same other columns so, I see between missed the formula & write there #N/A please solve my problem & please tell me what I do????? Please please
Sir mene ek attandace sheet create ki hai par problem hai usme total 200 employee ke naam hai jinko mujhe find karke fill karna parta hai kuch easy bataye
Hii sir agar bahut pic save Kiya h aur sab pic ka alag alag name h aur uska nomber bhi h wo mujhe dhoodhne me pareshaani hoti h koi trick btao ki us pic ka name ya number enter kru to pic open ho Jaye plz help me sir
Ofcourse its long process you are always changing values in formula for every column and then you are opening files n then again changing its time consuming
If we are preparing inventory and we have local purchase products and for those products price change on daily basis and in this regards we repeat same product like rice we purchased on Monday and again we purchased rice on Tuesday the price are different and we want in excel to count rice one time and take Monday and Tuesday price average
Sir, Isse Bhi Short Trick Bataiye. Ye Bhi To Lengthy Hi Hai. Yadi 100 Files Ho, To Un Sabhi Ko Open Karke Lookup Array Ya Range Select Karna Padegi. Kya Rows Ya Columns Formula Ki Tarah Workbook or Sheet Name Se Direct Access Ka Tarika Nahi Ho Sakta? Kya Vlookup Me Hyperlink Karke Array Formula Ban Sakta Hai Kya???
If a person knows that he has to retrieve data from multiple files and knowing this if his is still making different files for different locations; regret he is the most genuine fool on the earth. The best practice is 1) To keep all the data in same file but in different sheets, 2) Use cell function with "filename" the result of which will include sheet name also, 3) Isolate the sheet name using combo of search, replace function and then use sumif or sumifs as the case may be..
For example, if I write one, I have maintained a formula, then I write the second formula, 3, I write the formula, you should tell the formula of lakhs.
You having files name only 1,2,3,4,5,6.xls. etc which is easy to edit in formula. But in case our files name is different to each other and in long sentence then we will have to type that name. So, that we make the formula difficult to edit... Any solution? Please revert or make an other video.
Sir mughe Nidhi company loan RD Saving account details and debit credit satetme excel sheet par kaise banaye please sir banaye your mobile number please
Wow nice. Sir your voice is good.
Thanks for this video sir video thodi big rakho Ms advance excel ki
Bhaut shandar awaj h sir.........apki...bilkul radio jockey ki tarah........or bhut shandar detail Di h sir...
Very helpful video, thanks, yeah tho aapny workbook select ki thi, kya hum workbook ky अंदर sheets पर भी यह formula apply कर सकते हैं
Your formula is best my life
Kya is example me iphone ka data ko index match ka use karke laya ja sakta hai
thanks sir,this is very helpful video for me.thanks sir.
Very nice
Want to sum yearly data in multiple worksheets in a workbook using vlookup
Please inform how to do or in which of your video concept is available
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
very easy Thanks🙏
Thank you guruji
your Formula is very useful and helpful for me
Thanks sir for sharing.....
Good
Wah Guru Ji. Kya baat he
वाह! आवाज़ में भी दम
बहुत शानदार तरीके से बताया गया है
Sukriya dost
Aapki or vedio ki links de please
I was looking for this kind of video. Thanku
واہ کیا لاجواب ویڈیو بنائی ہے۔گھر بیٹھے ایکسل میں مہارت حاصل ہو رہی ہے۔
Awesome
In case of sabhi data upar niche ho to search karega???
hello sir my name Aditya nice class and your voice very nice I love your voice
Thanks, Guruji. I understood perfectly.
Great! Today I got new idea in this Video
Very informative sir as usual I have a question can u suggest me I want to do PMP course
If data of 100 files having different column and row then it will work or not
Aman Kaushik not work
I want to do vlookup with two different excel file not sheet. Is it possible?
Sir i have 2500 item how to maintenance purchase, issue balace
Good morning sir,
Best teacher !!
Nice!!
Hello, I can't find the file used in the video on your website.
Please share the file-link in the description.
Thanks :)
Sir please account book for 100no excel shet me kaise banaye
Sir sumif k formule k sath range bhi bde uske liye kaise formula lagayenge
Can I use the indirect function to choose the sheet?
Worried about Interviee, ckeck out d latest Excel interview question and answer
ua-cam.com/video/RMcEn2pYgO8/v-deo.html
Plz tell me is thr any process to change file name automaticaly??
Formula may job without log korke motlob simple vlookup ka reault Aya to usi result ko ctrl press korke drag korne se Kya Sara ka result ayega ?
Worried about Interviee, ckeck out d latest Excel interview question and answer
ua-cam.com/video/RMcEn2pYgO8/v-deo.html
it's vlookup video very important and helpful for work.thank you guruji.
Thank You Sir
Sir how to vlookup from multipule dynemic workbook.
Sir I do it but I face one problem when I copy to put formula & drag down same other columns so, I see between missed the formula & write there #N/A please solve my problem & please tell me what I do????? Please please
Sir,agar hame ek sheet se ek hi naam ka alag alag data hai to uska sum karke kaise jayega dusre sheet mein...guide plz
Sir mene ek attandace sheet create ki hai par problem hai usme total 200 employee ke naam hai jinko mujhe find karke fill karna parta hai kuch easy bataye
Thanks Sir but my question is how can be get colunm dynamically, I don't want to change colunm.
Thanks
Sir
For that you may use the Columns function instead of entering the column number or use a index and match formula instead of Vlookup
Sir can we use reserve vlookup with multiple work sheets
If yes please provide 1 example
I Can do that for you.
Thanks Guru! : )
Bro how to find number common in 10 column? Please help to slove this my problem
Sir Mera question hai Ki agar same data different sheet me hai to signal vlookup kaise lagega, Eksheet me check karne Ke liye please reply.
Hii sir agar bahut pic save Kiya h aur sab pic ka alag alag name h aur uska nomber bhi h wo mujhe dhoodhne me pareshaani hoti h koi trick btao ki us pic ka name ya number enter kru to pic open ho Jaye plz help me sir
🙏 Guruji
Sir kya ek sat 50 files ka data nhi aa skta h
Workbook ko bina open kiye bhi laga ja skta he
Kya aap ek video bana sakte ho jisme sale register month by month spin button ke sath change ho sake
Wow
bhai,
The computer will hang if 100 files are opened and its long process too
Ofcourse its long process you are always changing values in formula for every column and then you are opening files n then again changing its time consuming
What if the look up workbook password protected
Thanks sir
Sir kya koi dusra short cut tarika hai
Why you can't use match formula to take sheet number. Changing sheet number is repetitive task
hi, u have very nice voice, y dont u try RJ.
sir agar product name sam na hu to pr
Worried about Interviee, ckeck out d latest Excel interview question and answer
ua-cam.com/video/RMcEn2pYgO8/v-deo.html
Sheet open nai krni or data pull krna hai. Tb kese hoga guru ji???
sir 1 video controll penal setting ki video bana do na plz sir hini m banana
Sir Vlookup ko copy kar ke dusare jaga pest kar ke colum number chenge kar ke kese use kar te hai
Purushotam kumar $ use karo
If we are preparing inventory and we have local purchase products and for those products price change on daily basis and in this regards we repeat same product like rice we purchased on Monday and again we purchased rice on Tuesday the price are different and we want in excel to count rice one time and take Monday and Tuesday price average
excel এ vlookup worksheet dynamic করা যাবে কিভাবে
Sir, Isse Bhi Short Trick Bataiye. Ye Bhi To Lengthy Hi Hai. Yadi 100 Files Ho, To Un Sabhi Ko Open Karke Lookup Array Ya Range Select Karna Padegi. Kya Rows Ya Columns Formula Ki Tarah Workbook or Sheet Name Se Direct Access Ka Tarika Nahi Ho Sakta?
Kya Vlookup Me Hyperlink Karke Array Formula Ban Sakta Hai Kya???
If a person knows that he has to retrieve data from multiple files and knowing this if his is still making different files for different locations; regret he is the most genuine fool on the earth. The best practice is 1) To keep all the data in same file but in different sheets, 2) Use cell function with "filename" the result of which will include sheet name also, 3) Isolate the sheet name using combo of search, replace function and then use sumif or sumifs as the case may be..
Yes, U R Correct.
Thanks
Nice one but instead of typing or changing the sheet names repeatedly, can we use macro?
Sir screen per likha huaa dikha ya kro ase samjh nhi ata hai
For example, if I write one, I have maintained a formula, then I write the second formula, 3, I write the formula, you should tell the formula of lakhs.
Sir 10000 se jyda rows m filter kese use kre ... 10000 se niche ki rows ko filter m show nhi kr rhha
Helpful, lookup value occurs in multiple time in a workbook its not work
Very helpful but I have a question. Ki agar iPhone ka data kisi or sheet me kisi doosari cell me ho tab.?
Tab alag se vlookup lagana padega, because vlookup is column address dependent.
What is the concept of ,3&,0
sir me school me job karta hu to mujhe school ki file banani hai to aap apni email id send karo
श्री मान जी टैली का भी विडियो बनाईये क्योंकि जो आप समझा सकते हैं वो कोई और नहीं कर सकता
👍
Thank you. To see our latest videos please visit www.myelesson.org/
Learn ---- vlookup with help of put 2 common thing's?
Sheet name bar bar change na krne pade , use dynamic kaise banaye
bohat acha hai, lekin sir hum ek formule me sare offices ka data show nahi karsakte jaise hum isse pahle wale video me kiya tha.
एक शीट मै अलग अलग कम्पनी का सभी प्रोडक्ट का योग दूसरी शीट पे कैसे आएगा
How to make compound unit in excel
We should approached every column to change sheet number... Not so cool
🙏🏻
Use match index bcoz every sheet, cell or colum is changr
M 5 max 6 files files p ek sat kam krta hu. Or har work book m 4,6 sheets hote h. I am feeling luck. Shm ko gr ake sapne m excel sheet goomti rehti h
There have more easier than this iferror with vlookup
You having files name only 1,2,3,4,5,6.xls. etc which is easy to edit in formula. But in case our files name is different to each other and in long sentence then we will have to type that name. So, that we make the formula difficult to edit...
Any solution?
Please revert or make an other video.
Nisha Dutta : Actually guruji even do not know. I have very easy methods to do so. Contact me
Its good,but if all sheet data is not same then its not usefull
Good sir, but time consuming process. Sir ye to 50 excel thi agar isse jada hoto bar bar excel open krenge aur time lgayenge. This is lengthy process.
Sheet name baar baar change hi Karna hai to isme sikhane wali baat hi Kya rahi
Sir mughe Nidhi company loan RD Saving account details and debit credit satetme excel sheet par kaise banaye please sir banaye your mobile number please
But it's very long way, any short way...
Sir your style of speaking and to some extent voice is similar to SALMAAN KHAN.
⁵⁵
मुझे 1 ही शीट मे 150 अकाउंट की एन्ट्री date वाईझ कैसे करू e.g A , b ,c , d , ..z and Date वाईझ कैसे करू
9869321766 फोन नंबर
Aap RJ hai kya
Kyu thak rahe ho.... Power query lagao....
I
know easier process than this. Those who want to know comment here.
Sayan Pal I want to know
Share
Thank you Sir .
Sir g naya kya tha isme
File not download bad service company customer review is -5 star