New to Formuals

External Since: May 02, 2006 Posts: 69

I would like to set up my excel sheet to auto calculate. The problem I have
multiple factors to column B
B C D
1 Product code A 100 ?
2 Product code B 50 ?
3 Product code C 25 ?

I want to be able to have a formula in cell D that will look to see if it's
any of the product codes something like if B1=product code A then (c1*20), or
if B1=product code b then (c1*50)

Thanks in advanced!

External Since: Mar 17, 2004 Posts: 2612

First, set up a lookup table in say cols G & H,
eg in G1:H1 down you'd have:
Product code A 20
Product code B 50
Product code C 80
etc

Then you could use in D1:
=C1*VLOOKUP(B1,G:H,2,0)
and copy D1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tanya" wrote:
> I would like to set up my excel sheet to auto calculate. The problem I have
> multiple factors to column B
> B C D
> 1 Product code A 100 ?
> 2 Product code B 50 ?
> 3 Product code C 25 ?
>
> I want to be able to have a formula in cell D that will look to see if it's
> any of the product codes something like if B1=product code A then (c1*20), or
> if B1=product code b then (c1*50)
>
> Thanks in advanced!