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
|