Auto Pull and multiple
Hi!
I have a sheet called "Recipes Table" with all components needed for produce something. Then a sheet called "Production Plan" that should use the previous sheet to make the necessary multiplications in other to know the materials needed.
See attached the workbook and its marked in RED what I'm looking for to automate.
For the simplest solution:
1. Omit the blank columns in Asembly.
2. Place the components (column A) in the SAME order in Plan & Recipes.
3. Use this in Plan E2, copied down:
=IFERROR(SUM((INDEX('Recipes Table'!$B$2:$P$14,ROWS('Recipes Table'!$A$2:$A2),MATCH(Assembly!$B$2:$C$2,'Recipes Table'!$B$1:$P$1,0))*(Assembly!$B$4:$C$4))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you for the reply. But for me the formula doesn't work. Show zero on almost every line.
Attachment 727255
1. Your attachment is invalid.
2. This is what I see... and seems to be correct...
Yes, this is also what I see. Its not the expected value. The problem is more complex.
Did you see that in column I "Calc V4", to produce 1 Calc v4, I need 1 plastic case and others. So I need to SUM ALL the materials not just 1 plastic case. I need it to sum
- Plastic case: 1
- Plastic Parts: 3
- Plastic: 15 (12 to produce 3 plastic parts + 4 needed to produce 1 plastic case)
This is what I need, the real sum of all components based on the final product.
What is needed to produce 1 plastic case? Its in the plastic case column. 4 plastic and 3 plastic parts. What is needed to produce 3 plastic parts? 4 plastic.
I can't put that on Calc v4 column as it would be a duplication. Its implicit inside Plastic Case.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Undeclared cross post? I'm out. Good luck!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks