Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |