If formula with table look up
 

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.

If formula with table look up
 

Hi,
try

=IF(A1=VLOOKUP(A1,$A$11:$B$16,1,FALSE),B1*VLOOKUP( A1,$A$10:$B$15,2,FALSE))

I assumed that your table is in A11 to B16 , change it to fit your needs

"goonie" wrote:

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.

If formula with table look up
 

I made a few cell reference adjustments and it worked Wonderfully!!!

Thanks so much for your help!!!! It saved me a lot of work the sheet had
over 400 rows .

"Eduardo" wrote:

Hi,
try

=IF(A1=VLOOKUP(A1,$A$11:$B$16,1,FALSE),B1*VLOOKUP( A1,$A$10:$B$15,2,FALSE))

I assumed that your table is in A11 to B16 , change it to fit your needs

"goonie" wrote:

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.

If formula with table look up
 

Your welcome, thanks for the feedback

"goonie" wrote:

I made a few cell reference adjustments and it worked Wonderfully!!!

Thanks so much for your help!!!! It saved me a lot of work the sheet had
over 400 rows .

"Eduardo" wrote:

Hi,
try

=IF(A1=VLOOKUP(A1,$A$11:$B$16,1,FALSE),B1*VLOOKUP( A1,$A$10:$B$15,2,FALSE))

I assumed that your table is in A11 to B16 , change it to fit your needs

"goonie" wrote:

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.