v look value dependant on 2 cells
 

what I am trying to do is calculate a formula based on the following:

what I am trying to do a generate a V look up dependent on 2 cells

I need to look at cell b15 ( material thickness eg 1/8")
as well I need know if what the material is ( eg 316 or 304)
in order to tell calulate the cost of the material per pound.

the spread sheet of V look up has 3 columns
column A = size ( eg 1/8", 1/2" etc )
column B= 304 price / sq ft
column C= 316 price / sq ft

I am trying to generate the price / sq foot( for lets say cell E15) based on
the material thickness and type of material 304 or 316 so that I can
incorporate it into another formula


I hope this make sense.. help!

--
Donna

v look value dependant on 2 cells
 

Assuming material type is in A15 and thickness in B15 then use something like
=IF(A15=304, VLOOKUP1, VLOOKUP2)

where VLOOKUP1 is
=VLOOKUP(B15,Sheet2!A:C,2,False)
and VLOOKUP2 is
=VLOOKUP(B15,Sheet2!A:C,3,False)

i.e.
=IF(A15=304, VLOOKUP(B15,Sheet2!A:C,2,False)
, VLOOKUP(B15,Sheet2!A:C,3,False))

Assuming lookup data is in Sheet2.

"Tacklem
om" wrote:

what I am trying to do is calculate a formula based on the following:

what I am trying to do a generate a V look up dependent on 2 cells

I need to look at cell b15 ( material thickness eg 1/8")
as well I need know if what the material is ( eg 316 or 304)
in order to tell calulate the cost of the material per pound.

the spread sheet of V look up has 3 columns
column A = size ( eg 1/8", 1/2" etc )
column B= 304 price / sq ft
column C= 316 price / sq ft

I am trying to generate the price / sq foot( for lets say cell E15) based on
the material thickness and type of material 304 or 316 so that I can
incorporate it into another formula


I hope this make sense.. help!

--
Donna

v look value dependant on 2 cells
 

Try this...

...........A............B..........C
1.....................304......316
2......1/8".........10.........12
3......1/4".........14.........17
4......3/8".........20.........25
5......1/2".........27.........35

E1 = 3/8"
F1 = 304

=VLOOKUP(E1,A1:C5,MATCH(F1,A1:C1),0)

--
Biff
Microsoft Excel MVP


"Tacklemom" wrote in message
...
what I am trying to do is calculate a formula based on the following:

what I am trying to do a generate a V look up dependent on 2 cells

I need to look at cell b15 ( material thickness eg 1/8")
as well I need know if what the material is ( eg 316 or 304)
in order to tell calulate the cost of the material per pound.

the spread sheet of V look up has 3 columns
column A = size ( eg 1/8", 1/2" etc )
column B= 304 price / sq ft
column C= 316 price / sq ft

I am trying to generate the price / sq foot( for lets say cell E15) based
on
the material thickness and type of material 304 or 316 so that I can
incorporate it into another formula


I hope this make sense.. help!

--
Donna