Help in finding smallest value for given criteria

Hello Friends,

I need a help in developing logic and small code for below small data. I have courier company names and their rates to deliver goods of type A, B, C to given pin code. I want to develope a small code in which I will give object type (A, B,C) and Pin code. It will return me 'Courier company name' with lowest fare.

Input --> Pin code & A/B/C
Output --> Courier

Any kind of help is greatly appreciated.

Courier Pin Code A B C
BLUEDART 110001 219 447 561
BLUEDART 110002 219 447 561
BLUEDART 110003 219 447 561
BLUEDART 110004 219 447 561
DELHIVERY 110001 410 410 410
DELHIVERY 110002 410 410 410
DELHIVERY 110003 137 137 137
SAW- DTDC 110001 258 270 281
SAW- DTDC 110002 258 270 281
SAW- DTDC 110003 258 270 281

Assuming data in A1:E11 range including header.

Pin Code in I2, Object Type (A/B/C) in J2

Formula would be...
=INDEX($A$2:$A$11,MATCH(I2&MIN(INDEX($C$2:$E$11,IF(B2:B11=I2,ROW(2:11)+1),MATCH(J2,C1:E1,0))),B2:B11&INDEX(C2:E11,,MATCH(J2,C1:E1,0)),0))

Confirmed as array. See attached sample.

Note: Depending on data set, you may want to add separator (such as "-") between concatenations.

Thanks a lot CK76. You are genious
I didn't think about match index before. In the excel you attached, it is giving #N/A for Pin code - 110002 for all objects. What can be the reason?

Originally Posted by FDibbins

Did you enter that using CTRL SHIFT ENTER and not just enter? It is an array formula

Yes, I did try with CTRL SHIFT ENTER. Same #N/A error.

Woops, my bad. I didn't fully test the formula. Go with Ankur's formula.