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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Aetna
[/TD]
[TD]BCBS
[/TD]
[TD]Health Net
[/TD]
[TD]Dean
[/TD]
[TD]Geisinger
[/TD]
[/TR]
[TR]
[TD]Bronze
[/TD]
[TD]10
[/TD]
[TD]N/A
[/TD]
[TD]100
[/TD]
[TD]35
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Bronze Plus
[/TD]
[TD]15
[/TD]
[TD]N/A
[/TD]
[TD]50
[/TD]
[TD]45
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]Gold
[/TD]
[TD]20
[/TD]
[TD]N/A
[/TD]
[TD]75
[/TD]
[TD]55
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]Silver
[/TD]
[TD]30
[/TD]
[TD]N/A
[/TD]
[TD]25
[/TD]
[TD]65
[/TD]
[TD]20
[/TD]
[/TR]
</tbody>[/TABLE]

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))),"")