Help with this formula!

[chrisrowe_cr]

Morning all,

=INDEX('[PPfV F A.xls]input plus'!$D$1755:$D$1798,MATCH(1,('[PPfV F
A.xls]input plus'!$DJ$1755:$DJ$1798=E5)*('[PPfV F A.xls]input
plus'!$DG$1755:$DG$1798=MIN('[PPfV F A.xls]input
plus'!$DG$1755:$DG$1798)),0))

What im trying to achieve is for the formula to always pick the lowest
and next lowest value from the range DG1755G1798 based on E5 always
being a set value.

example: E5 specifies a risk value (say 2). DG1755G1798 contains
products with a product rating.

ie the no1 product has a risk val of 2
..........no2 product has a risk val of 2
..........no3 product has a risk val of 4
..........no4 product has a risk val of 2

What I want is for that formula to report back product 1, 2 and 4
IGNORING product 3 because its risk val is different.

Im nearly there, but not quite, any help is greatly appreciated!

 

[Biff]

Hi!

ie the no1 product has a risk val of 2
..........no2 product has a risk val of 2
..........no3 product has a risk val of 4
..........no4 product has a risk val of 2

What I want is for that formula to report back product 1, 2 and 4
IGNORING product 3 because its risk val is different.

The formula can only return a single value. Based on your explanation above,
you'd need 3 formulas but then it would get really complicated judging from
the possible combinations of risk values.

What if all of the above had a rv of 2, would you want all 4 products
returned? If so, then you'd need 4 formulas.

Biff

"chrisrowe_cr" <[email protected]>
wrote in message
news:[email protected]...