Hi All,

I have a formula where I wish to locate the minimum or cheapest rate available to us per below:

=MIN(IF(Rates!$A$6:$A$145=Calculator!$D$6,IF(Rates!$D$4:$S$4=Calculator!$D$12,IF(Rates!$D$5:$S$5=Calculator!$D$14,Rates!$D$6:$S$145))))

This works fine and returns the value I require, however in another cell I also need it to tell me the carrier which is in column C of the same 'Rates' Sheet that corresponds with this lowest or cheapest value.


Thanks,
Gaz