I have multiple data in colums and I want to have a formula that will let me
do an if multipler. I'm using excel 2003. Example:

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


Reference Table:
Admin Uplift Factors
FD 1.20
PC 1.03
PR 1.52
SIJ 1.00
TD 1.32
TS 1.63

I would like to put a formula in column C - If column A matches table
reference then Multiple Column B by factor in lookup table.

Hope this makes sense.