# Excle formula

Solved/Closed
Ulhas - May 9, 2012 at 05:40 AM
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- May 10, 2012 at 09:22 AM
Hello,

Dear People,
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.

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 .

Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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