Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list with two possible numbers but each number has several criteria
A1 B1 C1 DIAMETER LENGTH MAX WEIGHT 70 48 368 70 60 245 70 72 145 100 48 700 100 60 550 100 72 450 I am looking for the result from column a based on both the length and weight which is located on another worksheet say cells f15 for the length and k15 for the weight. I have tried this formula but it always returned the same resulkt of 70 which is incorrect. INDEX($AP$3:$AP$36,MATCH(1,('ROLL CUT SHEET'!M27<=FORMULAS!$AQ$3:$AQ$36)*(FORMULAS!AG15 =$AR$3:$AR$36),0))) using ctrl+shift+enter. Thank you so much for assistance in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a number based on a criteria | Excel Worksheet Functions | |||
Return number OR sum based on two criteria | Excel Worksheet Functions | |||
LookUp with Mulitple Criteria | Excel Discussion (Misc queries) | |||
mulitple criteria | Excel Discussion (Misc queries) | |||
returning a value based on mulitple criteria | Excel Worksheet Functions |