Hello -
I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. The following formula works, however, I'm wondering if there is a way to write it w/out using { } as it is giving our API issues. Current formula
<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
Is there a way to write this w/out { }?
I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. The following formula works, however, I'm wondering if there is a way to write it w/out using { } as it is giving our API issues. Current formula
Code:
{=IFERROR(INDEX($F$55:$O$55,SMALL(IF(INDEX($F$56:$O$60,MATCH("Bronze",$E$56:$E$60,0),0)=MIN(INDEX($F$56:$O$60,MATCH("bronze",$E$56:$E$60,0),0)),COLUMN($F$56:$O$60)-COLUMN($F$56)+1),ROWS($C$86:C86))),"")}
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
Is there a way to write this w/out { }?
Last edited: