Hi sir, can u please upload the video for compare the different Excel data and print the 1 St column values ( Excel sheet search Pani antha row values print multiple places la iruntha it should copy the values and print)
Bro....Filter mode mein vlookup kaisa us kare with iferror. Means jo task allocate hua hai wuska hi time aana chaiye. Example: whenever If I select B task, put unit has 3 then estimated time automatically multiply with the condition 2 and result will be 6. Any suggestion. condition given task time per unit A 4 B 2 C 3 Output in filter mode task unit estimated A 10 40 B 20 40 C 15 45
Consolidate all the sheets into one using the following concept ruclips.net/video/DCLZiqesxxQ/видео.html Then, ஒரே ஒரு vlookup formula போட்டு output ஈசியா எடுத்திடலாம்.
can solve following eg using Excel formulas.... we have set of numbers ( lets say 5,6,8,9,4,6,10 ( set A) and also another set of numbers 7,6,4,3,8,6,2 ( Set B: derived by subtracting set A nos. from 12), now, we need to find out minimum number from set B which is more than the any set A number .. I.E, lets take 5 from set A. in the set B , 7,6,8 & 6 are higher than this selected 5, and in which ( 7,6,8 & 6) minimum is 6. likewise need to develop formulae for, 6,8,9,4,6 & 10 ( Set A) to find out minimum number. can help me to solve this
I have one doubt sir, if the data is changed in the source file... It will automatically populate in the formula sheet every time they change.. Correct?
Bro, Vlookup use panni, Oru Sheet la irukura Workingsa Salary slip Mari kondu Vara mudiuma??? Name & Department ah Vlookup panni Salary slip ah konduvara mudiuma??
Good question, If you feel the column is in different place, you have to open the file and develop the Formula, copy and paste doesn't not help in that cause.
No, nested formulas look like this. Or else, combine all the files into one file and develop vlookup formula. Use auto combine with the help of PowerQuerry.
ஓ!!! இப்படியும் vlookup ல விளையாடலாமா!!!!! Power query option ல மட்டும் தான் இதெல்லாம் பண்ண முடியும் என்று நினைத்தேன். ஆனால் இது நல்ல பதிவு.... நன்றி.....
மத்து இல்லாமல் தயிரை கடைந்து வெண்ணை எடுத்த பலனை இந்த vlookup காட்சியில் பெற்றேன்.
என்னுடைய excellant நன்றிகள் பல.
உங்களுடைய பதிவை பார்ப்பதில் மகிழ்ச்சி.
Wonderful explanations thank you very much Prabas ms office
Thanks sir in this scenario one my work task
very useful learning
My doubt was cleared in the video
Thank you sir......
Keep rocking sir continues ah more videos podunga........
It’s a amazing video sir
Thank you so much it will help me more to know about excel
Wow..super sir...I understand
video 5.23 to 5.32 is usefull for me, thanks
sir, oru sheetla 3 column data verify pannanum from main sheet la irundhu ,athuku vlookup with if error forumula use pannalama
Super sir, thank you sir after down load practice this videos I I well ask my douth sir
It familiar to me plz go to next level 👍
Sure
Very useful.
Saravanan.M: Multiple iferror.. it new for me. Understood🙏
Hi sir, can u please upload the video for compare the different Excel data and print the 1 St column values ( Excel sheet search Pani antha row values print multiple places la iruntha it should copy the values and print)
VBA can help you with this scenario.
We can also use nested IF.
And we can use power query for advance method.
Yes you can use use IF function.
@@Prabasmsoffice can you please show 'nested IF' video if you already have it, thanks
Can we use dimension as table to fetch the fact table to work dynamically. Without changing the table array reference
It is new, thank you.
Bro....Filter mode mein vlookup kaisa us kare with iferror. Means jo task allocate hua hai wuska hi time aana chaiye.
Example: whenever If I select B task, put unit has 3 then estimated time automatically multiply with the condition 2 and result will be 6. Any suggestion.
condition given
task time per unit
A 4
B 2
C 3
Output in filter mode
task unit estimated
A 10 40
B 20 40
C 15 45
Can you guide me the method to do vlookup in ms access? It’s called dlookup
In vlookup Multiple conditions more than 2 in that case , which formula will help.
Sema sir video
Sir ennoda office la one sheetla date wise (1 to 30) sheet irukkum, I want monthly abstract for the month statement.... how to do simple this????
Consolidate all the sheets into one using the following concept ruclips.net/video/DCLZiqesxxQ/видео.html
Then, ஒரே ஒரு vlookup formula போட்டு output ஈசியா எடுத்திடலாம்.
Hi,how to change symbols color.
can solve following eg using Excel formulas.... we have set of numbers ( lets say 5,6,8,9,4,6,10 ( set A) and also another set of numbers 7,6,4,3,8,6,2 ( Set B: derived by subtracting set A nos. from 12), now, we need to find out minimum number from set B which is more than the any set A number .. I.E, lets take 5 from set A. in the set B , 7,6,8 & 6 are higher than this selected 5, and in which ( 7,6,8 & 6) minimum is 6. likewise need to develop formulae for, 6,8,9,4,6 & 10 ( Set A) to find out minimum number. can help me to solve this
Watched sir
I have one doubt sir, if the data is changed in the source file... It will automatically populate in the formula sheet every time they change.. Correct?
Yes you are right.
how to combine this all spreadsheet into a single sheet, so that it will easy to use vlookup single time.
Use the following concept to consolidate your data:
ruclips.net/p/PLXqX9fbIzJMbaZT0rcZQyKJSrBR76Yb0r
@@Prabasmsoffice thanks
How to dependent drop-down in excel
ruclips.net/video/WbOS3cjRqO0/видео.html
Bro, Vlookup use panni, Oru Sheet la irukura Workingsa Salary slip Mari kondu Vara mudiuma???
Name & Department ah Vlookup panni Salary slip ah konduvara mudiuma??
முடியும்
@@Prabasmsoffice Na unga Videos pathutu Try pannuna bro... But Correcta varala... Name lookup pannuna.. N/A varuthu... But 1 kudutha output varuthu bro.. Adhuku Edhavathu Videos Poda mudiuma bro?
காடயமாக ஒரு வீடியோ போடுறேன்
Ok but what if the data available in different columns in a files , without opening the file how could I represent the column number ?
Good question,
If you feel the column is in different place, you have to open the file and develop the Formula, copy and paste doesn't not help in that cause.
Iferror seems to be large .....is it possible to present it commonly?
No, nested formulas look like this.
Or else, combine all the files into one file and develop vlookup formula. Use auto combine with the help of PowerQuerry.
@@Prabasmsoffice💪
Sir.... I understood but innum short ahhhh???
இன்னும் சின்னதா வேணும்னா, consolidation பண்ணி then Vlookup use பண்ணனும்.
It's ok sir. But I want multiple Excel sheet use in only one formula how it's possible pls mention
I will try to Publish it in future video .
How to apply this on google sheets
I will make a dedicated video for this. Stay tuned.
Sir enaku excella vlookupla oru problem unga whatsup number koduka mudiyingla sir
Share your working Excel file to prabas.msoffice@gmail.com along with your problem.
Sir unga mailuku send panni iruken
Noted
It's a new concept, try to convert one big file to two, three small file, if I have any doubt let me update the same
ஓ!!! இப்படியும் vlookup ல விளையாடலாமா!!!!!
Power query option ல மட்டும் தான் இதெல்லாம் பண்ண முடியும் என்று நினைத்தேன். ஆனால் இது நல்ல பதிவு.... நன்றி.....
Yes விளையாடலாம்.
Anna unga Ph no ha kudunga oru doubt kekanum
Plz konjam whatsapp la yachum msg panu nga
Please share your requirements to prabas@prabastech.com
Okay