Large function with criteria.

Hello,

I have been learning excel and found it interesting using the functions. Doing so I am stuck in a situation where I have to use a LARGE function with a criteria to select a specific value.
Please fetch the attached file Grid India - Cable Selection.xlsx and refer the below points.

Notes :
Yellow cells are the Input values consisting of manual input in (C4) and drop down selection in (D4:G4)
Green is where I need the final output (I4).

Problem faced :
Red is the cell I need to work on. Here the next LARGE value (w.r.t. C4) popping up should also fulfill the criterias of all other yellow cells (input cells).

Please guide me.
Thanks!

Quote from bosco_yip

Try,

In H4, enter formula :

=AGGREGATE(15,6,H9:H30/(D9:D30=D4)/(E9:E30=E4)/(F9:F30=F4)/(G9:G30=G4)/(H9:H30>=C4),1)

Regards

Display More

This is exactly what I was looking for. That data sheet enitirely has about 560+ alternate combinations.
You have made it easy for me to search the required data.
Thank you.