Looking up values bound by more than one condition

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:

Please Login or Register  to view this content.

in combination with an if() to catch non-existing data.

This works just fine

For SOLUTION_B, I've got this:

Formula:

Please Login or Register  to view this content.

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.

Hi

Figured it might be confusing... Attached the sheet is available as I have it (except for the Parameter_B values, but since that's a rather simple VLOOKUP, it was not really necessary to include all the data just to get the correct value).

Thank you for your quick reply though.

Overview.xlsx