Pricing Comparison

[Bitty]

		Company 1	( LBS)					Company 2							Company 3
Orig	Dest	Min$	100	1000	2000	5000	10000	Min$	100	500	1000	3000	5000	7500	Min$	100	500	1000	2000	3000	5000	7500
ATL
	BHM	$25.95	$7.76	$7.12	$6.30	$4.76	$3.45	$39.82	$13.36	$13.09	$12.54	$12.03	$11.34	$10.67	$40.00	$11.13	$10.89	$10.40	$9.92	$9.92	$9.31	$8.70
	BNA	$25.95	$8.47	$7.76	$6.97	$5.40	$4.24	$39.82	$12.50	$12.22	$11.74	$11.27	$10.63	$9.99	$40.00	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80
	BWI	$34.60	$11.25	$10.31	$10.12	$9.37	$8.25	$39.82	$25.92	$25.39	$24.34	$23.35	$22.04	$20.74
	CHA	$25.95	$7.76	$6.90	$6.04	$5.21	$2.81
	CLT	$25.95	$4.46	$4.46	$4.27	$4.05	$3.26	$39.82	$12.13	$11.88	$11.40	$10.93	$10.33	$9.70	$40.00	$7.45	$7.45	$7.45	$7.45	$7.45	$7.45	$7.45

<tbody>
</tbody>

Hello All,

I am attempting to compare three carrier companies. I would like to find the lowest rates in multiple categories. I am not married to the formatting, I just don't know where to start with this project. Please see example above ...


Please help

 

[AhoyNC]

Maybe this will give you a start. I put each company in it's own table, but you could use the format you have above. If you could have different origins then you would need to add a vlookup to find the proper table. I also changed the min$ to 0 assuming min dollars would be for shipments under 100 lbs.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Company 1								Origin	ATL	Dest	BNA
2		0	100	1000	2000	5000	10000				Weight	2200
3	BHM	$25.95	$7.76	$7.12	$6.30	$4.76	$3.45				Rate	6.80
4	BNA	$25.95	$8.47	$7.76	$6.97	$5.40	$4.24				Company	Company 3
5	BWI	$34.60	$11.25	$10.31	$10.12	$9.37	$8.25
6	CHA	$25.95	$7.76	$6.90	$6.04	$5.21	$2.81
7	CLT	$25.95	$4.46	$4.46	$4.27	$4.05	$3.26
8
9	Company 2
10		0	100	500	1000	3000	5000
11	BHM	$39.82	$13.36	$13.09	$12.54	$12.03	$11.34
12	BNA	$39.82	$12.50	$12.22	$11.74	$11.27	$10.63
13	BWI	$39.82	$25.92	$25.39	$24.34	$23.35	$22.04
14	CHA
15	CLT	$39.82	$12.13	$11.88	$11.40	$10.93	$10.33
16
17
18
19	Company 3
20		0	100	500	1000	2000	3000	5000	7500
21	BHM	$40.00	$11.13	$10.89	$10.40	$9.92	$9.92	$9.31	$8.70
22	BNA	$40.00	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80
23	BWI
24	CHA
25	CLT	$40.00	$7.45	$7.45	$7.45	$7.45	$7.45	$7.45	$7.45
26
27
Sheet

 

[Bitty]

After applying this to my entire project, it worked perfectly! Thank you very much.