Excle formula

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 .