mutliple matches for v lookup

[Tacklemom]

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

 

[Pete_UK]

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(B1922,MATCH(A9,A19:A22,0),MATCH(A7,B1818,0))

Hope this helps.

Pete

 

[Tacklemom]

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

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(B1922,MATCH(A9,A19:A22,0),MATCH(A7,B1818,0))

Hope this helps.

Pete



.