Company 1 | Company 2 | Company 3 | Company 4 | ||||||||||
Destination | Origin | 0 (Min $) | 100 lbs. | 1000 lbs. | 0 (Min $) | 100 lbs. | 500 lbs. | 0 (Min $) | 100 lbs. | 500 lbs. | 0 (Min $) | 100 lbs. | 500 lbs. |
DFW | ATL | $25.95 | $7.76 | $7.12 | $39.82 | $13.36 | $13.09 | $40.00 | $11.13 | $10.89 | $26.00 | $10.47 | $9.97 |
CVG | CLT | $34.60 | $13.80 | $13.80 | $39.82 | $23.58 | $23.12 | $40.00 | $19.00 | $19.00 | $39.50 | $20.94 | $19.95 |
GSP | EWR | $45.00 | $11.25 | $10.50 | $39.82 | $21.81 | $20.82 | $40.00 | $19.00 | $19.00 | $33.50 | $21.64 | $19.95 |
<tbody>
</tbody>
Hello All,
I am attempting to put together a price comparison spreadsheet, but I am having trouble figuring a formula to return the necessary information. There is approximately 9,000 Origin/Destination combinations to be searched in the formula. What I need is:
1.) A formula to search for the origin, destination, and closest weight.
2.) I then need the formula to return the lowest cost (of four competing carrier's).
3.) I will then need a second formula to return the name of the carrier.
4.) If possible I would like to rank all four carrier's in descending order.
Please see example above...
I am unsure of how to post an example of my worksheet. I believe seeing an example would help tremendously. Please reply, if only to help with posting example.
Thank you,
Bitty