# 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).

Thanks!

• 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

• 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.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!