Spreadsheet: 117734d1312993792-vlookup-with-nested-if-statments-fob_stor-x_vancouver
Sheet: RGA060

*----------- | -------- | ---------------- | ------- | ----- | -------------------- | -------- | --------- | --------- | ---------- | ---------- | -----*
Origin | Prov | Destination | Prov | Funds | Min Chg | LTL | 5C | 1M | 2M | 5M | 10M
 |  |  |  |  |  | 250 | 500 | 1000 | 2000 | 5000 | 10000 |  |  | Shipping Weight
*----------- | -------- | ---------------- | ------- | ----- | -------------------- | -------- | --------- | --------- | ---------- | ---------- | -----* |  |  | 500
[NAME] | BC | ARMSTRONG | BC | C | 52.7 | 1485 | 1353 | 1094 | 853 | 715 | 569
[NAME] | BC | BARRIE | ON | C | 78.68 | 1815 | 1653 | 1375 | 1178 | 1177 | 1132
[NAME] | BC | BLACKFALDS | AB | C | 84.15 | 1651 | 1335 | 1099 | 862 | 808 | 698
[NAME] | BC | BOLTON | ON | C | 78.16 | 1803 | 1644 | 1366 | 1174 | 1160 | 1127
[NAME] | BC | BRANDON | MB | C | 82.73 | 2183 | 1989 | 1668 | 1343 | 1241 | 1099 |  |  | Select your city
[NAME] | BC | BRANTFORD | ON | C | 78.43 | 1810 | 1649 | 1371 | 1177 | 1162 | 1130 |  |  | ARMSTRONG
[NAME] | BC | BROOKS | AB | C | 84.15 | 1651 | 1335 | 1099 | 862 | 808 | 698
[NAME] | BC | BURNS LAKE | BC | C | 60.93 | 1786 | 1628 | 1215 | 956 | 881 | 755
[NAME] | BC | CALGARY | AB | C | 55.38 | 1343 | 1224 | 1003 | 738 | 628 | 534
[NAME] | BC | CAMPBELL RIVEr | BC | C | 78.72 | 1499 | 1366 | 1192 | 837 | 727 | 542
[NAME] | BC | CASTLEGAR | BC | C | 58.74 | 1427 | 1300 | 1020 | 752 | 640 | 547
[NAME] | BC | CHATHAM | ON | C | 80.23 | 1850 | 1687 | 1403 | 1207 | 1203 | 1150
[NAME] | BC | CHETWYND | BC | C | 52.8 | 1534 | 1397 | 1170 | 912 | 825 | 720
[NAME] | BC | CONSORT | AB | C | 84.15 | 1795 | 1452 | 1196 | 937 | 852 | 735
[NAME] | BC | COWANSVILLE | PQ | C | 79.26 | 2116 | 1928 | 1585 | 1380 | 1371 | 1277
[NAME] | BC | CRANBROOK | BC | C | 58.52 | 1420 | 1294 | 1024 | 793 | 720 | 620
[NAME] | BC | CRESTON | BC | C | 64.27 | 1561 | 1422 | 1125 | 818 | 748 | 593
[NAME] | BC | DAWSON CREEK | BC | C | 55.25 | 1604 | 1462 | 1223 | 952 | 858 | 749
[NAME] | BC | DRUMHELLER | AB | C | 84.15 | 1651 | 1335 | 1099 | 862 | 808 | 698
[NAME] | BC | EDMONTON | AB | C | 61.31 | 1468 | 1337 | 1063 | 799 | 697 | 601
[NAME] | BC | ELKFORD | BC | C | 57.82 | 1404 | 1280 | 1025 | 794 | 721 | 621
[NAME] | BC | ENDAKO | BC | C | 63.99 | 1800 | 1641 | 1370 | 1138 | 1000 | 832
[NAME] | BC | ENDERBY | BC | C | 56.21 | 1615 | 1472 | 1094 | 853 | 715 | 569
[NAME] | BC | ESTEVAN | SK | C | 85.15 | 2110 | 1922 | 1519 | 1179 | 1114 | 921
[NAME] | BC | FERGUS | ON | C | 79.3 | 1829 | 1668 | 1386 | 1191 | 1164 | 1142
[NAME] | BC | FERNIE | BC | C | 58.28 | 1415 | 1289 | 1024 | 793 | 720 | 620
[NAME] | BC | FORT FRASER | BC | C | 63.98 | 1799 | 1640 | 1370 | 1138 | 1000 | 832
[NAME] | BC | FORT MCMURRAY | AB | C | 83.62 | 1884 | 1716 | 1393 | 1094 | 1005 | 874
[NAME] | BC | FORT NELSON | BC | C | 65.59 | 1818 | 1656 | 1374 | 1108 | 1036 | 919
[NAME] | BC | FORT ST JAMES | BC | C | 63.6 | 1794 | 1633 | 1366 | 1109 | 1029 | 796
[NAME] | BC | FORT ST JOHN | BC | C | 56.63 | 1663 | 1515 | 1268 | 991 | 894 | 769
[NAME] | BC | FRASER LAKE | BC | C | 63.13 | 1798 | 1640 | 1370 | 1138 | 1000 | 832
[NAME] | BC | GRANBY | PQ | C | 77.25 | 2062 | 1879 | 1544 | 1343 | 1322 | 1228
[NAME] | BC | GRANDE PRAIRIE | AB | C | 64.73 | 1677 | 1529 | 1258 | 986 | 896 | 775
[NAME] | BC | GRINDROD | BC | C | 56.21 | 1615 | 1472 | 1094 | 853 | 715 | 569
[NAME] | BC | GUELPH | ON | C | 78.13 | 1803 | 1644 | 1365 | 1177 | 1162 | 1130
[NAME] | BC | HAMILTON | ON | C | 77.91 | 1797 | 1639 | 1361 | 1171 | 1164 | 1128
[NAME] | BC | HANNA | AB | C | 84.15 | 1795 | 1452 | 1196 | 937 | 852 | 684
[NAME] | BC | HARDISTY | AB | C | 84.15 | 1795 | 1452 | 1196 | 937 | 852 | 684
[NAME] | BC | HOUSTON | BC | C | 59.88 | 1682 | 1533 | 1281 | 964 | 893 | 759
[NAME] | BC | JOFFRE | AB | C | 84.15 | 1651 | 1335 | 1099 | 862 | 808 | 698
[NAME] | BC | KAMLOOPS | BC | C | 43.64 | 1191 | 1085 | 848 | 597 | 484 | 395
[NAME] | BC | KELOWNA | BC | C | 46 | 1243 | 1133 | 898 | 639 | 521 | 430
[NAME] | BC | KIMBERLEY | BC | C | 58.52 | 1420 | 1294 | 1024 | 793 | 720 | 620
[NAME] | BC | KINGSTON | ON | C | 77.7 | 1793 | 1633 | 1358 | 1178 | 1164 | 1127
[NAME] | BC | KITCHENER | ON | C | 78.43 | 1810 | 1649 | 1371 | 1177 | 1162 | 1130
[NAME] | BC | [NAME] | BC | C | 60.8 | 1778 | 1621 | 1351 | 1072 | 983 | 874
[NAME] | BC | LAVINGTON | BC | C | 52.7 | 1485 | 1353 | 1094 | 853 | 715 | 569
[NAME] | BC | LETHBRIDGE | AB | C | 59 | 1440 | 1312 | 1037 | 778 | 677 | 576
[NAME] | BC | LISTOWEL | ON | C | 81.49 | 1881 | 1714 | 1425 | 1218 | 1211 | 1163
[NAME] | BC | LLOYDMINSTER | AB | C | 71.89 | 1617 | 1472 | 1177 | 944 | 843 | 722
[NAME] | BC | LONDON | ON | C | 77.53 | 1789 | 1630 | 1355 | 1172 | 1150 | 1120
[NAME] | BC | MACKENZIE | BC | C | 61.38 | 1765 | 1608 | 1340 | 1109 | 977 | 815
[NAME] | BC | MASSET | BC | C | 79.92 | 2416 | 2201 | 1850 | 1559 | 1534 | 1356
[NAME] | BC | MEDICINE HAT | AB | C | 62.81 | 1513 | 1378 | 1090 | 828 | 730 | 626
[NAME] | BC | MONTREAL | PQ | C | 78.49 | 1811 | 1650 | 1372 | 1189 | 1164 | 1151
[NAME] | BC | MOOSE JAW | SK | C | 69.38 | 1686 | 1537 | 1299 | 1069 | 962 | 811
[NAME] | BC | NANAIMO | BC | C | 51.9 | 1132 | 1031 | 928 | 659 | 533 | 441
[NAME] | BC | NELSON | BC | C | 59.88 | 1454 | 1326 | 1040 | 766 | 650 | 555
[NAME] | BC | OAKVILLE | ON | C | 77.03 | 1777 | 1620 | 1347 | 1161 | 1155 | 1116
[NAME] | BC | OLDS | AB | C | 84.15 | 1651 | 1335 | 1099 | 862 | 808 | 698
[NAME] | BC | ORANGEVILLE | ON | C | 78.66 | 1816 | 1653 | 1375 | 1178 | 1155 | 1131
[NAME] | BC | ORILLIA | ON | C | 78.68 | 1815 | 1653 | 1375 | 1178 | 1177 | 1132
[NAME] | BC | OSHAWA | ON | C | 79.3 | 1829 | 1668 | 1386 | 1193 | 1164 | 1139
[NAME] | BC | OSOYOOS | BC | C | 55.5 | 1576 | 1436 | 1093 | 853 | 715 | 569
[NAME] | BC | OTTAWA | ON | C | 78.11 | 1802 | 1643 | 1392 | 1206 | 1162 | 1105
[NAME] | BC | OWEN SOUND | ON | C | 82.34 | 1899 | 1731 | 1439 | 1228 | 1222 | 1171
[NAME] | BC | PENTICTON | BC | C | 48.29 | 1314 | 1198 | 932 | 663 | 539 | 446
[NAME] | BC | PETERBOROUGH | ON | C | 81.4 | 1878 | 1712 | 1422 | 1218 | 1216 | 1163
[NAME] | BC | PORT ALBERNI | BC | C | 81.55 | 1704 | 1553 | 1376 | 1094 | 980 | 758
[NAME] | BC | PORT CLEMENTS | BC | C | 78.77 | 2378 | 2167 | 1822 | 1538 | 1511 | 1339
[NAME] | BC | [NAME] | SK | C | 83.53 | 2050 | 1868 | 1471 | 1149 | 1109 | 940
[NAME] | BC | [NAME] | BC | C | 49.76 | 1378 | 1256 | 1047 | 786 | 685 | 588
[NAME] | BC | [NAME] | BC | C | 62.37 | 1806 | 1647 | 1372 | 1098 | 1019 | 906
[NAME] | BC | QUEBEC | PQ | C | 93.48 | 2156 | 1965 | 1542 | 1318 | 1302 | 1251
[NAME] | BC | QUEEN CHARLOTTE | BC | C | 84.53 | 2385 | 2175 | 1797 | 1514 | 1489 | 1326
[NAME] | BC | QUESNEL | BC | C | 58.88 | 1431 | 1305 | 1102 | 831 | 729 | 597
[NAME] | BC | RED DEER | AB | C | 66.91 | 1610 | 1468 | 1160 | 866 | 756 | 644
[NAME] | BC | REGINA | SK | C | 67.87 | 1618 | 1474 | 1220 | 958 | 873 | 770
[NAME] | BC | SARNIA | ON | C | 86.18 | 1989 | 1812 | 1506 | 1243 | 1221 | 1159
[NAME] | BC | SASKATOON | SK | C | 66.52 | 1584 | 1444 | 1196 | 933 | 845 | 741
[NAME] | BC | SMITHERS | BC | C | 54.41 | 1558 | 1419 | 1185 | 926 | 839 | 734
[NAME] | BC | SPARWOOD | BC | C | 58.14 | 1413 | 1287 | 1025 | 794 | 720 | 620
[NAME] | BC | ST CATHARINES | ON | C | 82.2 | 1896 | 1729 | 1437 | 1207 | 1187 | 1121
[NAME] | BC | ST GEORGES | PQ | C | 93.79 | 2163 | 1972 | 1547 | 1344 | 1322 | 1227
[NAME] | BC | ST JEROME | PQ | C | 88.53 | 2042 | 1862 | 1547 | 1340 | 1326 | 1230
[NAME] | BC | STETTLER | AB | C | 84.15 | 1651 | 1335 | 1099 | 862 | 808 | 698
[NAME] | BC | SUDBURY | ON | C | 92.45 | 2166 | 1975 | 1693 | 1440 | 1374 | 1228
[NAME] | BC | SWIFT CURRENT | SK | C | 77.67 | 1922 | 1752 | 1397 | 1150 | 1088 | 881
[NAME] | BC | TERRACE | BC | C | 57.07 | 1664 | 1516 | 1283 | 1015 | 930 | 823
[NAME] | BC | TORONTO | ON | C | 76.99 | 1777 | 1620 | 1345 | 1159 | 1139 | 1116
[NAME] | BC | TRAIL | BC | C | 60.27 | 1464 | 1334 | 1046 | 771 | 654 | 558
[NAME] | BC | TROIS RIVIEREs | PQ | C | 77.25 | 2062 | 1879 | 1544 | 1343 | 1322 | 1228
[NAME] | BC | VANDERHOOF | BC | C | 54.63 | 1527 | 1392 | 1158 | 900 | 819 | 690
[NAME] | BC | VERNON | BC | C | 46.83 | 1283 | 1170 | 927 | 660 | 537 | 444
[NAME] | BC | VICTORIA | BC | C | 50 | 1142 | 1042 | 938 | 668 | 545 | 451
[NAME] | BC | VICTORIAVILLE | PQ | C | 79.26 | 2116 | 1928 | 1585 | 1380 | 1371 | 1277
[NAME] | BC | WEYBURN | SK | C | 81.69 | 1995 | 1819 | 1438 | 1165 | 1099 | 899
[NAME] | BC | WHITEHORSE | YT | C | 81.4 | 2336 | 2105 | 1750 | 1475 | 1437 | 1327
[NAME] | BC | [NAME] LAKE | BC | C | 58.04 | 1410 | 1286 | 1067 | 756 | 657 | 530
[NAME] | BC | WINDSOR | ON | C | 86.1 | 1986 | 1810 | 1505 | 1244 | 1218 | 1159
[NAME] | BC | WINNIPEG | MB | C | 64.94 | 1714 | 1562 | 1309 | 1051 | 983 | 891
[NAME] | BC | WOODSTOCK | ON | C | 78.26 | 1805 | 1645 | 1367 | 1180 | 1166 | 1129
[NAME] | BC | 100 [NAME] | BC | C | 71.49 | 1739 | 1585 | 1282 | 964 | 852 | 629