Hello -
I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates.
<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.
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.