Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a formula for set of data. The user picks to options and from a chart
I need the number brought back. Example Norway Maple Yes 9.5 Red Maple Yes 15 Silver Maple Yes 19 Norway Maple No 9.5 Red Maple No 15 Silver Maple No 19 I user would put in red maple and no...and 15 would be brought back. I was using the code =INDEX(N3:N48,MATCH(Ctree,L3:L48,0),MATCH(CLeaf,M3 :M48,0)) Ctree = type of tree Cleaf = yes or no Now it would bring the answer back for any values with Yes but nothing for No's. There was a reference error....Any Suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |