View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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