View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tacklemom Tacklemom is offline
external usenet poster
 
Posts: 17
Default 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