There are several ways, depending on how long your list of carriers is:
or:
or:
For the last option, you need to make a list of the carriers and their rates ... in this case, cells H1:I3.
It has the advantage that is is more flexible and you can add entries if you need to.
If you make the list into a Named Range, say, CarrierTable, you can use:
And you can convert the list to a Table and then Excel will manage the Named Range so you can add entries. The most flexible option.
See the attached sample workbook.
Regards, TMS
Bookmarks