Help with this formula!
 

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 DG1755:DG1798 based on E5 always
being a set value.

example: E5 specifies a risk value (say 2). DG1755:DG1798 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!


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile: http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=388982