Looking Up the intersection point in a table that matches multiple criteria

[oneal1767]

I have a list of cities in column A with a set of values assigned to them in column B. Is there a formula I can use to determine which cities values would go together with the sum being between two numbers and without including more than three cities. For example if the range that the sum must be between is 15,000 to 16,000, I need to know all the possible scenarios of pairing the cities up where the sum of the values assigned to them will equal this range. Also keep in mind this could be the sum of up to 3 of the numbers. Then I have a list of the same cities in a table showing the distance between each city. Is there a way to take the scenarios given from above and analyze them so it will identify the shortest distance to travel? I've pasted a section of this table below. What I'm trying to do is to create a file that will help me to plan deliveries. The table below will show all of the cities that we deliver to. The list of cities will have the weight of material I have to deliver in each city. I'd like to determine which cities could be paired together without going over three stops where the weight would be within the range listed above, and then determine the best route. For example City A may be able to be matched with either city B or city C, but the distance between city A and B is less than between city A and C. Therefore I would want to match A and B together.

Row Labels	AGRICOLA, MS	ARABI, LA	ATMORE, AL	BAKER, FL	BATON ROUGE, LA	BAY MINETTE, AL	BAY SPRINGS, MS	BAY ST LOUIS, MS
AGRICOLA, MS	0	136	76	129	192	60	107	84
ARABI, LA	136	0	192	236	85	176	163	58
ATMORE, AL	76	192	0	55	248	20	169	140
BAKER, FL	131	236	55	0	292	75	216	184
BATON ROUGE, LA	192	84	248	292	0	232	207	114
BAY MINETTE, AL	60	176	20	75	232	0	152	124
BAY SPRINGS, MS	107	163	168	216	206	152	0	136
BAY ST LOUIS, MS	84	59	140	184	114	124	136	0

<colgroup><col width="142" style="width: 106pt; mso-width-source: userset; mso-width-alt: 5034;"> <col width="114" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4039;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3640;"> <col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3527;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3299;"> <col width="136" style="width: 102pt; mso-width-source: userset; mso-width-alt: 4835;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4579;"> <col width="131" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4664;"> <col width="133" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4721;"> <tbody>
</tbody>