Simplify formula exceeds 64 levels of nested formula - Best Carrier Rate

[TwinJohnson]

The table holds pricing from three carriers and a column to say which carrier is the best one to use for the weight entered for each of the 86 countries worldwide. I'm building a formula that says when the weight is inputted the output should be the carrier with the best pricing by weight and country. I started the vlookup and got to 64 if(vlookup scenarios and received the error that the formula cannot exceed 64 levels of nested formula so I'm trying to figure out an alternative formula.

Note all the carriers are not shown and the formula shown is incomplete. I've identified the column with the expected results provided in the second screen shot.

Perhaps there is another formula to use to get the results needed.

Thank you,
Tawnee

 

[Fluff]

If you get rid of the merged cells & put the country code above the Carrier columns only, you can use

=INDEX(E4:Y7,MATCH(B12,A2:A7,0),MATCH(C13,E2:Y2,0))

 

[TwinJohnson]

If you get rid of the merged cells & put the country code above the Carrier columns only, you can use

=INDEX(E4:Y7,MATCH(B12,A2:A7,0),MATCH(C13,E2:Y2,0))

Thank you so much Fluff, it was that easy to just format it correctly. I'm still learning index matches and see the starting place is key (E4) as provides the column the result is in.

 

[Fluff]

You're welcome & thanks for the feedback.