Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup value if multiple matches are met | Excel Worksheet Functions | |||
Lookup with multiple matches | Excel Discussion (Misc queries) | |||
lookup mutliple values to return one value | Excel Worksheet Functions | |||
Multiple matches using LOOKUP | Excel Discussion (Misc queries) | |||
Multiple matches using LOOKUP | Excel Worksheet Functions |