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!

  • 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. :):thumbup: