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!