Hi, I have a list of postcodes in column A, carriers in column B, and their rates in column C as below. I'm looking for a for a formula to replace "XXX" under the lowest cost section to look up the postcode in the list in column A and return the applicable carrier from column B based on which carriers rate is lowest in column C. I've tried mixing the INDEX, MATCH and MIN functions but can't get it to work correctly. Does anyone know if and how this can be achieved? Once I've got "XXX" sorted, I'll be able to use the same method for "YYY" to show the lowest rate. Cheers for your help!!
[TABLE="width: 558"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 558"]
<colgroup><col><col><col span="4"><col><col></colgroup><tbody>[TR]
[TD]Postcode[/TD]
[TD]Carrier[/TD]
[TD]Rate[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Lowest Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cw10[/TD]
[TD]carrier 1[/TD]
[TD="align: right"]180[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Carrier[/TD]
[TD]Rate[/TD]
[/TR]
[TR]
[TD]cw10[/TD]
[TD]carrier 2[/TD]
[TD="align: right"]187[/TD]
[TD][/TD]
[TD][/TD]
[TD]cw10[/TD]
[TD]XXX[/TD]
[TD]YYY[/TD]
[/TR]
[TR]
[TD]cw10[/TD]
[TD]carrier 3[/TD]
[TD="align: right"]188[/TD]
[TD][/TD]
[TD][/TD]
[TD]cw8[/TD]
[TD]XXX[/TD]
[TD]YYY
[/TD]
[/TR]
[TR]
[TD]cw8[/TD]
[TD]carrier 2[/TD]
[TD="align: right"]180[/TD]
[TD][/TD]
[TD][/TD]
[TD]st4[/TD]
[TD]XXX[/TD]
[TD]YYY[/TD]
[/TR]
[TR]
[TD]cw8[/TD]
[TD]carrier 1[/TD]
[TD="align: right"]181[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cw8[/TD]
[TD]carrier 3[/TD]
[TD="align: right"]190[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]st4[/TD]
[TD]carrier 3[/TD]
[TD="align: right"]270[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]st4[/TD]
[TD]carrier 1[/TD]
[TD="align: right"]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]st4[/TD]
[TD]carrier 2[/TD]
[TD="align: right"]255[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 558"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 558"]
<colgroup><col><col><col span="4"><col><col></colgroup><tbody>[TR]
[TD]Postcode[/TD]
[TD]Carrier[/TD]
[TD]Rate[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Lowest Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cw10[/TD]
[TD]carrier 1[/TD]
[TD="align: right"]180[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Carrier[/TD]
[TD]Rate[/TD]
[/TR]
[TR]
[TD]cw10[/TD]
[TD]carrier 2[/TD]
[TD="align: right"]187[/TD]
[TD][/TD]
[TD][/TD]
[TD]cw10[/TD]
[TD]XXX[/TD]
[TD]YYY[/TD]
[/TR]
[TR]
[TD]cw10[/TD]
[TD]carrier 3[/TD]
[TD="align: right"]188[/TD]
[TD][/TD]
[TD][/TD]
[TD]cw8[/TD]
[TD]XXX[/TD]
[TD]YYY
[/TD]
[/TR]
[TR]
[TD]cw8[/TD]
[TD]carrier 2[/TD]
[TD="align: right"]180[/TD]
[TD][/TD]
[TD][/TD]
[TD]st4[/TD]
[TD]XXX[/TD]
[TD]YYY[/TD]
[/TR]
[TR]
[TD]cw8[/TD]
[TD]carrier 1[/TD]
[TD="align: right"]181[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cw8[/TD]
[TD]carrier 3[/TD]
[TD="align: right"]190[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]st4[/TD]
[TD]carrier 3[/TD]
[TD="align: right"]270[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]st4[/TD]
[TD]carrier 1[/TD]
[TD="align: right"]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]st4[/TD]
[TD]carrier 2[/TD]
[TD="align: right"]255[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]