Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |||
Lookup and Display Multiple Unique values based on criteria | Excel Worksheet Functions | |||
Lookup and Display Multiple Unique values based on criteria | Excel Worksheet Functions | |||
Lookup based on multiple criteria | New Users to Excel | |||
Index/Match - Lookup based on multiple column criteria | Excel Worksheet Functions | |||
Lookup based on two criteria in 1 row | Excel Discussion (Misc queries) |