If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|