Excle formula
Solved/Closed
Ulhas
-
May 9, 2012 at 05:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2012 at 09:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2012 at 09:22 AM
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 10, 2012 at 09:22 AM
May 10, 2012 at 09:22 AM
Hi Ulhas,
When you know which Raw materials are needed for a Component, you can use multiple VLOOKUP's to gather the total price for the Components.
This would solve the first 4 points.
Point 5 I don't understand. What different path? You are using multiple sheets in one file, right?
6. ???, You would like to rename the components and raw material?
Best regards,
Trowa
When you know which Raw materials are needed for a Component, you can use multiple VLOOKUP's to gather the total price for the Components.
This would solve the first 4 points.
Point 5 I don't understand. What different path? You are using multiple sheets in one file, right?
6. ???, You would like to rename the components and raw material?
Best regards,
Trowa