v look value dependant on 2 cells

T

Tacklemom

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!
 
S

Sheeloo

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
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top