Function that meets table requirement then multiplies by table fac

[goonie]

I'm looking for a function that will reference a cell then lookup that cell
in a table and use the multiplier in the table. I'm not explaining very well
so Im hoping that my example will help you understand:

Column
A b c
Sector P&L w/o Admin P&L w/ Admin
PC 517.9
PC 0.0
PC 0.0
TD 1,993.6
TD (2,508.0)
TS 431.3
TS 355.7

Table reference:
FD 1.20
PC 1.03
PR 1.52
SIJ 1.00
TD 1.32
TS 1.63


In column C I would like to put a formula that; if column A mactches column
A in table reference then it will mutiple column B * column B in refernce
table.

I hope the example helpd you to understand. I'm using excel 2003

Thanks

 

[Eduardo]

Hi,
See your previous post

 

[goonie]

I saw the previous answer.

Sorry about the double post. I didn't see that the other post was posted
until I had typed another.