Hi all

I've got the following dataset:
Name Result_1 Result_2 Parameter_B
String Float Float String (VLOOKUP depending on "Name")
String Float Float String (VLOOKUP depending on "Name")
String Float Float String (VLOOKUP depending on "Name")


In a new sheet I would like an overview like this:

Parameter_B = 1 Parameter_B = 2 Parameter_B = 3
-------------------------------------------------------------------------------------
Minimal value SOLUTION_A
Name at minimum value SOLUTION_B

Parameter_B = value_1 Parameter_B = value_2 Parameter_B = value_3
Minimal value SOLUTION_A
Name at minimal value SOLUTION_B


For SOLUTION_A, I've got this:
Formula: copy to clipboard 
=DMIN('data-sheet'!$Result_1$1:$Parameter_B$1048576;'data-sheet'!$Result_1$1;'new-sheet'!Parameter_B)
in combination with an if() to catch non-existing data.

This works just fine

For SOLUTION_B, I've got this:
Formula: copy to clipboard 
=IF(ISNA(INDEX( correct range ;MATCH( minimal value calculated above ;range;0);1)); "Not tested yet"; NAME AT MINIMAL VALUE = copy formula in first part of if statement)


This works wonderfully well if the minimal value for Parameter_B is the first encountered in the data sheet. But if there exists a minimal value in Result_1 for a Name that is not corresponding with the appropriate Parameter_B, it returns (quite logically) Name for the first value that is equal to minimal value - which is not necessarily the correct answer I'm looking for.

Any idea's on how to surpass this error; preferably without the use of matrix-formulae?

Thank you in advance

-Smetje


PS: any comments on coding so far is welcome as well.