Spreadsheet: 54986d1255021878-formula-cell-jumping-chart
Sheet: Sheet1

 | Weight |  |  | I want to enter weight here in C1
 | State |  |  | I want to enter State here in C2
 | What carrier |  |  | And then have cell [NAME] automatically generate what carrier to use based on cells C1 and C2
 |  |  |  | Basically  if  I had a shipment that weighed 600 lbs and it was going to ks, [NAME] should tell me to use fed
State w/ Capital | Mileage | State | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | Heavy weight | Hundred Weight
Montgomery, AL 36111 | 862 | al | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Juneau, AK 99801 | Boat | ak | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Phoenix, AZ 85501 | 1868 | [NAME] | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Little Rock, AR 72201 | 870 | ar | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Sacramento, CA 94203 | 2292 | ca | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Denver, CO 80201 | 1234 | co | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Hartford, CT 06101 | 770 | ct | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Dover DE 19901 | 665 | de | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Tallahassee, FL 32301 | 1027 | fl | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Atlanta, GA 30301 | 778 | ga | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Honolulu, HI 96801 | N/A | hi | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Boise, ID 83702 | 1914 | id | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Springfield, IL 62701 | 431 | il | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Indianapolis, IN 46201 | 316 | in | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Des Moines, IA 50301 | 575 | [NAME] | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Topeka, KS 66601 | 786 | ks | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Frankfort, KY 40601 | 420 | ky | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Baton Rouge, LA 70801 | 1115 | la | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Augusta, ME 04330 | 983 | me | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Annapolis, MD 21401 | 628 | md | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Boston, MA 02108 | 865 | ma | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Lansing, MI 48901 | 65 | mi | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
St. Paul, MN 55101 | 587 | mn | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Jackson,MS 39201 | 961 | ms | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Jefferson City, MO 65101 | 624 | mo | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Helena,MT 59601 | 1666 | mt | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Lincoln,NE 68501 | 750 | ne | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Carson City,NV 89701 | 2147 | nv | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Concord, NH 03301 | 854 | nh | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Trenton ,NJ 08601 | 666 | nj | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Santa Fe, NM 87501 | 1448 | nm | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Albany, NY 12201 | 686 | ny | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Raleigh, NC 27601 | 727 | nc | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Bismark, ND 58501 | 1085 | nd | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Columbus, OH 43201 | 271 | oh | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Oklahoma City, OK 73101 | 1020 | ok | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Salem, OR 97301 | 2368 | or | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Harrisburg, PA 17101 | 554 | pa | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Providence, RI 02901 | 851 | ri | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Columbia, SC 29201 | 815 | sc | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Pierre, SD 57501 | 984 | sd | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Nashville, TN 37201 | 589 | tn | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
[NAME], TX 73301 | 1358 | tx | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Salt Lake City, UT 84101 | 1624 | ut | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Montpelier, VT 05602 | 825 | vt | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Richmond, VA 23230 | 667 | va | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Olympia, WA 98501 | 2304 | wa | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Charleston, WV 25301 | 434 | wv | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
[NAME], WI  53702 | 458 | wi | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old
Cheyenne, WY 82001 | 1215 | wy | fed | Conway | old | RL | fed | Conway | old | RL | fed | Conway | old