Menu
Ask a question Report

Excle formula [Solved/Closed]

- - Latest reply: TrowaD
Posts
2453
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
March 25, 2019
 - May 10, 2012 at 09:22 AM
Office Software Ask a question Report
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 
Related:

1 reply

Report Respond to TrowaD
Posts
2453
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
March 25, 2019
 412
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
Ask a question