Find the closet value

[Ajinkya]

hello,

I am looking for the excel function to find closet value from "Answer Column" from below table, where answer row should satisfy all given conditions from Input area.

DATA Table -

Sr. No. Data Set Answer Column A B C D E F 1 Alfa A 860 153 360 360 540 540 2 Alfa B 1200 214 410 410 625 625 3 Alfa C 1600 320 455 455 680 680 4 Beta D 2000 452 510 510 760 760 5 Beta E 2500 601 570 570 840 840 6 Beta F 3000 992 660 660 840 840 7 Alfa G 4500 1860 780 780 980 980 <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

INPUT Table -

		Conditions
Input 1	Alfa	Select Data Set with applting filter
Input 2	590	Input 2 <= A
Input 3	60	Input 3 <= (B*80%)
Input 4	20	Any Number
Input 5 (Max)	600	1. findout Max out of Input 5& Input6. 2. Min Input Value+(2*Input 4) <= D
Input 6 (Min)	300	1. findout Max out of Input 5& Input6. 2. Max Input <= E
Result	"B"	Closest Value from "Answer Column" where in that row all above conditions satisfies.

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

Guyz i need help.