Finding lowest cost carrier amoung an arry.

[kcgojnur]

Hello -

I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates.

	Aetna	BCBS	Health Net	Dean	Geisinger
Bronze	10	N/A	100	35	5
Bronze Plus	15	N/A	50	45	10
Gold	20	N/A	75	55	15
Silver	30	N/A	25	65	20

<tbody>
</tbody>

Looking to find a way that I can pull the name of the lowest cost carrier (Geisinger) in my example above. Table range is E55:O60.

I'm looking to have this the result in C87

Thanks.

 

[Peter_SSs]

If it is only the Ctrl+Shift+Enter confirmation that is the problem, might this standard-entry version be any use?
Again the formula in C87 is copied down to list any equal lowest cost carriers.

Book1
	C	D	E	F	G	H	I	J
5				Aetna	BCBS	Health Net	Dean	Geisinger
6			Bronze	10	N/A	5	35	5
7			Bronze Plus	15	N/A	50	45	10
8			Gold	20	N/A	75	55	15
9			Silver	30	N/A	25	65	20
86
87	Health Net
88	Geisinger
89
Lowest Cost

Cell Formulas
Range	Formula
C87	=IFERROR(INDEX(F$5:O$5,AGGREGATE(15,6,(COLUMN(F:O)-COLUMN(F:F)+1)/(INDEX($F$6:$O$60,MATCH("bronze",E$6:E$60,0),0)=MIN(INDEX($F$6:$O$60,MATCH("bronze",E$6:E$60,0),0))),ROWS(C$87:C87))),"")