From the archive

Task:

You coordinate outbound freight for a distribution center. The rate card prices every carrier-and-zone combination, but its key column stores both as one piece of text, carrier and zone joined with a hyphen, because XLOOKUP can only match a single column, not two at once. Each shipment in the queue lists its carrier and zone separately. In D2, join B2 and C2 the same way the rate card does and use XLOOKUP to pull the matching rate per lb — and for a carrier the rate card doesn't carry at all, show "Not quoted" instead of an error. Copy down to row 5.