mutliple matches for v lookup
I'm not sure what row your materials are on - assume row 18, so this
is where you want to find a match. Put this formula in A10:
=INDEX(B19:D22,MATCH(A9,A19:A22,0),MATCH(A7,B18:D1 8,0))
Hope this helps.
Pete
On Jan 29, 9:22*pm, Tacklemom
wrote:
Ok I need help on a formula that has two dependents to determine the end.
Eg lets say cell *A7 ( can = 304,316,c276, alloy 20 etc)
* * * * * * * * Cell A9 ( can = 30,60, 90, 120 *etcs)
* * * * * * * * Cell A10 = Weight per lbs ( what I am trying to get the
formula to return)
I am trying to come up with a formula that you look up the material in Cell
C7 and the size in Cell A9 to come up with the weight per lbs from *the chart
below
* * * *Columns * * * * * * * * *A * * * * * * * B * * * * * * * *C * * * * *
*D * * * * * * * * *E
* * * *(matrials) * * * * * * *304 * * * * * * 316 * * * * * * *c276 * * * *
alloy 20
( sizes)
Line 19 * * * * * *30 * * * *$ 2.00 * * * * * $ 1.59
* * * *20 * * * * * *60 * * * *$ 33.40 * * * *$ 2.82
* * * *21 * * * * * *90 *
* * * *22 * * * * * *120
* * * *23
--
Donna
|