Function that meets table requirement then multiplies by table fac

G

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
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top