Excle formula [Solved/Closed]

Ulhas - May 9, 2012 at 05:40 AM - Latest reply: TrowaD 2396 Posts Sunday September 12, 2010Registration dateContributorStatus July 19, 2018 Last seen
- May 10, 2012 at 09:22 AM
Hello,

Dear People,
I have a small Requirement in Excel. Can you please help me out?
Problem Description:
Content of Raw Material Prices are maintained in a Xl sheet.
These Material Prices are then used for Calculating the total Price of a Component in another Xl sheet using a Formula.
Requirements:
1. The Component Cost Xl File should be able to recognise the Raw Material Price File.
2. The Cost of the Material should be then read from 1st Excel sheet.
3. Calculation in the Component sheet should update depending on the Material Prices.
4. The Update should be carried out in a simplified mean, either by Macro or some other easier Method.
5. Integration steps should be easy and should take care of the Problems regarding different Paths.
6. The Extension of the Components as well as Material should be automatically taken care of (automation).


Like in one Colum Part name and in onther Colum Price of the same .
But at the time of component price calulation i need part name with price.
So please hepl me

Like

in Colum "A" Colum "B"
BUSBAR PIN Rate
3 way Pin Type 6.90
4 way Pin Type 8.96
5 way Pin Type 11.54
6 way Pin Type 13.64
7 way Pin Type 16.22
8 way Pin Type 20.00
9 way Pin Type 21.43
10 way Pin Type 28.57
11 way Pin Type 31.58
12 way Pin Type 28.57
13 way Pin Type 31.58
14 way Pin Type 33.33
15 way Pin Type 35.29
16 way Pin Type 37.50
17 way Pin Type 40.00
18 way Pin Type 42.86
19 way Pin Type 46.15


I need price in one colum and name in onther colum of the component costing .
See more 

1 reply

TrowaD 2396 Posts Sunday September 12, 2010Registration dateContributorStatus July 19, 2018 Last seen - May 10, 2012 at 09:22 AM
0
Thank you
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