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