mutliple matches for v lookup
 

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

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

mutliple matches for v lookup
 

Thank you very much it worked!!!!!
--
Donna


"Pete_UK" wrote:

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

.