Spreadsheet: 717247d1612540953-how-to-match-and-paste-value-for-multiple-conditions-volume-file
Sheet: Sea Freight Rates

Origin Port (name) | Origin Port (portcode) | Destination Port (name) | Destination Port (portcode) | Equipment type | Currency | Sea Freight Rate | Volume
NINGBO | CNNBO PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
XIAMEN | CNXAM PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
[NAME] MINH CITY | VNSGN PT | Bremerhaven | DEBRV PT | 20DC | USD | 400
NHAVA SHEVA | INNSA PT | Bremerhaven | DEBRV PT | 20DC | USD | 300
[NAME] | CNSNZ PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
SHANGHAI | CNSGH PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
FUZHOU | CNFZH PT | Bremerhaven | DEBRV PT | 20DC | USD | 450
SURABAYA | IDSUB PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
MADRAS-CHENNAI | INMAA PT | Bremerhaven | DEBRV PT | 20DC | USD | 450
YANTIAN | CNYTN PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
CHITTAGONG | BDCGP PT | Bremerhaven | DEBRV PT | 20DC | USD | 450
[NAME] | KHKOS PT | Bremerhaven | DEBRV PT | 20DC | USD | 575
RANGOON | MMRGN PT | Bremerhaven | DEBRV PT | 20DC | USD | 500
HAIPHONG | VNHPH PT | Bremerhaven | DEBRV PT | 20DC | USD | 450
KARACHI | PKKHI PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
BANGKOK | THBKK PT | Bremerhaven | DEBRV PT | 20DC | USD | 400
WENZHOU | CNWZO PT | Bremerhaven | DEBRV PT | 20DC | USD | 450
JAKARTA | IDJKT PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
QUINGDAO | CNQIN PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
HONGKONG | HKHKG PT | Bremerhaven | DEBRV PT | 20DC | USD | 350
CHOCHIN | INCOK PT | Bremerhaven | DEBRV PT | 20DC | USD | 450
NINGBO | CNNBO PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
XIAMEN | CNXAM PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
[NAME] MINH CITY | VNSGN PT | Bremerhaven | DEBRV PT | 40DC | USD | 700
NHAVA SHEVA | INNSA PT | Bremerhaven | DEBRV PT | 40DC | USD | 600
[NAME] | CNSNZ PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
SHANGHAI | CNSGH PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
FUZHOU | CNFZH PT | Bremerhaven | DEBRV PT | 40DC | USD | 750
SURABAYA | IDSUB PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
MADRAS-CHENNAI | INMAA PT | Bremerhaven | DEBRV PT | 40DC | USD | 600
YANTIAN | CNYTN PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
CHITTAGONG | BDCGP PT | Bremerhaven | DEBRV PT | 40DC | USD | 700
[NAME] | KHKOS PT | Bremerhaven | DEBRV PT | 40DC | USD | 975
RANGOON | MMRGN PT | Bremerhaven | DEBRV PT | 40DC | USD | 850
HAIPHONG | VNHPH PT | Bremerhaven | DEBRV PT | 40DC | USD | 750
KARACHI | PKKHI PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
BANGKOK | THBKK PT | Bremerhaven | DEBRV PT | 40DC | USD | 700
WENZHOU | CNWZO PT | Bremerhaven | DEBRV PT | 40DC | USD | 850
JAKARTA | IDJKT PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
QUINGDAO | CNQIN PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
HONGKONG | HKHKG PT | Bremerhaven | DEBRV PT | 40DC | USD | 650
CHOCHIN | INCOK PT | Bremerhaven | DEBRV PT | 40DC | USD | 600
NINGBO | CNNBO PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
XIAMEN | CNXAM PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
[NAME] MINH CITY | VNSGN PT | Bremerhaven | DEBRV PT | 40HC | USD | 700
NHAVA SHEVA | INNSA PT | Bremerhaven | DEBRV PT | 40HC | USD | 600
[NAME] | CNSNZ PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
SHANGHAI | CNSGH PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
FUZHOU | CNFZH PT | Bremerhaven | DEBRV PT | 40HC | USD | 750
SURABAYA | IDSUB PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
MADRAS-CHENNAI | INMAA PT | Bremerhaven | DEBRV PT | 40HC | USD | 600
YANTIAN | CNYTN PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
CHITTAGONG | BDCGP PT | Bremerhaven | DEBRV PT | 40HC | USD | 700
[NAME] | KHKOS PT | Bremerhaven | DEBRV PT | 40HC | USD | 975
RANGOON | MMRGN PT | Bremerhaven | DEBRV PT | 40HC | USD | 850
HAIPHONG | VNHPH PT | Bremerhaven | DEBRV PT | 40HC | USD | 750
KARACHI | PKKHI PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
BANGKOK | THBKK PT | Bremerhaven | DEBRV PT | 40HC | USD | 700
WENZHOU | CNWZO PT | Bremerhaven | DEBRV PT | 40HC | USD | 850
JAKARTA | IDJKT PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
QUINGDAO | CNQIN PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
HONGKONG | HKHKG PT | Bremerhaven | DEBRV PT | 40HC | USD | 650
CHOCHIN | INCOK PT | Bremerhaven | DEBRV PT | 40HC | USD | 600
NINGBO | CNNBO PT | Hamburg | DEHAM PT | 20DC | USD | 350
XIAMEN | CNXAM PT | Hamburg | DEHAM PT | 20DC | USD | 350
[NAME] MINH CITY | VNSGN PT | Hamburg | DEHAM PT | 20DC | USD | 400
NHAVA SHEVA | INNSA PT | Hamburg | DEHAM PT | 20DC | USD | 300
[NAME] | CNSNZ PT | Hamburg | DEHAM PT | 20DC | USD | 350
SHANGHAI | CNSGH PT | Hamburg | DEHAM PT | 20DC | USD | 350
KORSAKOV | CNSGH PT | Hamburg | DEHAM PT | 20DC | USD | 350
FUZHOU | CNFZH PT | Hamburg | DEHAM PT | 20DC | USD | 450
SURABAYA | IDSUB PT | Hamburg | DEHAM PT | 20DC | USD | 350
MADRAS-CHENNAI | INMAA PT | Hamburg | DEHAM PT | 20DC | USD | 450
YANTIAN | CNYTN PT | Hamburg | DEHAM PT | 20DC | USD | 350
CHITTAGONG | BDCGP PT | Hamburg | DEHAM PT | 20DC | USD | 450
[NAME] | KHKOS PT | Hamburg | DEHAM PT | 20DC | USD | 575
RANGOON | MMRGN PT | Hamburg | DEHAM PT | 20DC | USD | 500
HAIPHONG | VNHPH PT | Hamburg | DEHAM PT | 20DC | USD | 450
KARACHI | PKKHI PT | Hamburg | DEHAM PT | 20DC | USD | 350
BANGKOK | THBKK PT | Hamburg | DEHAM PT | 20DC | USD | 400
WENZHOU | CNWZO PT | Hamburg | DEHAM PT | 20DC | USD | 450
JAKARTA | IDJKT PT | Hamburg | DEHAM PT | 20DC | USD | 350
QUINGDAO | CNQIN PT | Hamburg | DEHAM PT | 20DC | USD | 350
HONGKONG | HKHKG PT | Hamburg | DEHAM PT | 20DC | USD | 350
CHOCHIN | INCOK PT | Hamburg | DEHAM PT | 20DC | USD | 450
NINGBO | CNNBO PT | Hamburg | DEHAM PT | 40DC | USD | 650
XIAMEN | CNXAM PT | Hamburg | DEHAM PT | 40DC | USD | 650
[NAME] MINH CITY | VNSGN PT | Hamburg | DEHAM PT | 40DC | USD | 700
NHAVA SHEVA | INNSA PT | Hamburg | DEHAM PT | 40DC | USD | 600
[NAME] | CNSNZ PT | Hamburg | DEHAM PT | 40DC | USD | 650
SHANGHAI | CNSGH PT | Hamburg | DEHAM PT | 40DC | USD | 650
FUZHOU | CNFZH PT | Hamburg | DEHAM PT | 40DC | USD | 750
SURABAYA | IDSUB PT | Hamburg | DEHAM PT | 40DC | USD | 650
MADRAS-CHENNAI | INMAA PT | Hamburg | DEHAM PT | 40DC | USD | 600
YANTIAN | CNYTN PT | Hamburg | DEHAM PT | 40DC | USD | 650
CHITTAGONG | BDCGP PT | Hamburg | DEHAM PT | 40DC | USD | 700
[NAME] | KHKOS PT | Hamburg | DEHAM PT | 40DC | USD | 975
RANGOON | MMRGN PT | Hamburg | DEHAM PT | 40DC | USD | 850
HAIPHONG | VNHPH PT | Hamburg | DEHAM PT | 40DC | USD | 750
KARACHI | PKKHI PT | Hamburg | DEHAM PT | 40DC | USD | 650
BANGKOK | THBKK PT | Hamburg | DEHAM PT | 40DC | USD | 700
WENZHOU | CNWZO PT | Hamburg | DEHAM PT | 40DC | USD | 850
JAKARTA | IDJKT PT | Hamburg | DEHAM PT | 40DC | USD | 650
QUINGDAO | CNQIN PT | Hamburg | DEHAM PT | 40DC | USD | 650
HONGKONG | HKHKG PT | Hamburg | DEHAM PT | 40DC | USD | 650
CHOCHIN | INCOK PT | Hamburg | DEHAM PT | 40DC | USD | 600
NINGBO | CNNBO PT | Hamburg | DEHAM PT | 40HC | USD | 650
XIAMEN | CNXAM PT | Hamburg | DEHAM PT | 40HC | USD | 650
[NAME] MINH CITY | VNSGN PT | Hamburg | DEHAM PT | 40HC | USD | 700
NHAVA SHEVA | INNSA PT | Hamburg | DEHAM PT | 40HC | USD | 600
[NAME] | CNSNZ PT | Hamburg | DEHAM PT | 40HC | USD | 650
SHANGHAI | CNSGH PT | Hamburg | DEHAM PT | 40HC | USD | 650
FUZHOU | CNFZH PT | Hamburg | DEHAM PT | 40HC | USD | 750
SURABAYA | IDSUB PT | Hamburg | DEHAM PT | 40HC | USD | 650
MADRAS-CHENNAI | INMAA PT | Hamburg | DEHAM PT | 40HC | USD | 600
YANTIAN | CNYTN PT | Hamburg | DEHAM PT | 40HC | USD | 650
CHITTAGONG | BDCGP PT | Hamburg | DEHAM PT | 40HC | USD | 700
[NAME] | KHKOS PT | Hamburg | DEHAM PT | 40HC | USD | 975
RANGOON | MMRGN PT | Hamburg | DEHAM PT | 40HC | USD | 850
HAIPHONG | VNHPH PT | Hamburg | DEHAM PT | 40HC | USD | 750
KARACHI | PKKHI PT | Hamburg | DEHAM PT | 40HC | USD | 650
BANGKOK | THBKK PT | Hamburg | DEHAM PT | 40HC | USD | 700
WENZHOU | CNWZO PT | Hamburg | DEHAM PT | 40HC | USD | 850
JAKARTA | IDJKT PT | Hamburg | DEHAM PT | 40HC | USD | 650
QUINGDAO | CNQIN PT | Hamburg | DEHAM PT | 40HC | USD | 650
HONGKONG | HKHKG PT | Hamburg | DEHAM PT | 40HC | USD | 650
CHOCHIN | INCOK PT | Hamburg | DEHAM PT | 40HC | USD | 600
NINGBO | CNNBO PT | [NAME] | NLRTM PT | 20DC | USD | 350
XIAMEN | CNXAM PT | [NAME] | NLRTM PT | 20DC | USD | 350
[NAME] MINH CITY | VNSGN PT | [NAME] | NLRTM PT | 20DC | USD | 400
NHAVA SHEVA | INNSA PT | [NAME] | NLRTM PT | 20DC | USD | 300
[NAME] | CNSNZ PT | [NAME] | NLRTM PT | 20DC | USD | 350
SHANGHAI | CNSGH PT | [NAME] | NLRTM PT | 20DC | USD | 350
FUZHOU | CNFZH PT | [NAME] | NLRTM PT | 20DC | USD | 450
SURABAYA | IDSUB PT | [NAME] | NLRTM PT | 20DC | USD | 350
MADRAS-CHENNAI | INMAA PT | [NAME] | NLRTM PT | 20DC | USD | 450
YANTIAN | CNYTN PT | [NAME] | NLRTM PT | 20DC | USD | 350
CHITTAGONG | BDCGP PT | [NAME] | NLRTM PT | 20DC | USD | 450
[NAME] | KHKOS PT | [NAME] | NLRTM PT | 20DC | USD | 575
RANGOON | MMRGN PT | [NAME] | NLRTM PT | 20DC | USD | 500
HAIPHONG | VNHPH PT | [NAME] | NLRTM PT | 20DC | USD | 450
KARACHI | PKKHI PT | [NAME] | NLRTM PT | 20DC | USD | 350
BANGKOK | THBKK PT | [NAME] | NLRTM PT | 20DC | USD | 400
WENZHOU | CNWZO PT | [NAME] | NLRTM PT | 20DC | USD | 450
JAKARTA | IDJKT PT | [NAME] | NLRTM PT | 20DC | USD | 350
QUINGDAO | CNQIN PT | [NAME] | NLRTM PT | 20DC | USD | 350
HONGKONG | HKHKG PT | [NAME] | NLRTM PT | 20DC | USD | 350
CHOCHIN | INCOK PT | [NAME] | NLRTM PT | 20DC | USD | 450
NINGBO | CNNBO PT | [NAME] | NLRTM PT | 40DC | USD | 650
XIAMEN | CNXAM PT | [NAME] | NLRTM PT | 40DC | USD | 650
[NAME] MINH CITY | VNSGN PT | [NAME] | NLRTM PT | 40DC | USD | 700
NHAVA SHEVA | INNSA PT | [NAME] | NLRTM PT | 40DC | USD | 600
[NAME] | CNSNZ PT | [NAME] | NLRTM PT | 40DC | USD | 650
SHANGHAI | CNSGH PT | [NAME] | NLRTM PT | 40DC | USD | 650
FUZHOU | CNFZH PT | [NAME] | NLRTM PT | 40DC | USD | 750
SURABAYA | IDSUB PT | [NAME] | NLRTM PT | 40DC | USD | 650
MADRAS-CHENNAI | INMAA PT | [NAME] | NLRTM PT | 40DC | USD | 600
YANTIAN | CNYTN PT | [NAME] | NLRTM PT | 40DC | USD | 650
CHITTAGONG | BDCGP PT | [NAME] | NLRTM PT | 40DC | USD | 700
[NAME] | KHKOS PT | [NAME] | NLRTM PT | 40DC | USD | 975
RANGOON | MMRGN PT | [NAME] | NLRTM PT | 40DC | USD | 850
HAIPHONG | VNHPH PT | [NAME] | NLRTM PT | 40DC | USD | 750
KARACHI | PKKHI PT | [NAME] | NLRTM PT | 40DC | USD | 650
BANGKOK | THBKK PT | [NAME] | NLRTM PT | 40DC | USD | 700
WENZHOU | CNWZO PT | [NAME] | NLRTM PT | 40DC | USD | 850
JAKARTA | IDJKT PT | [NAME] | NLRTM PT | 40DC | USD | 650
QUINGDAO | CNQIN PT | [NAME] | NLRTM PT | 40DC | USD | 650
HONGKONG | HKHKG PT | [NAME] | NLRTM PT | 40DC | USD | 650
CHOCHIN | INCOK PT | [NAME] | NLRTM PT | 40DC | USD | 600
NINGBO | CNNBO PT | [NAME] | NLRTM PT | 40HC | USD | 650
XIAMEN | CNXAM PT | [NAME] | NLRTM PT | 40HC | USD | 650
[NAME] MINH CITY | VNSGN PT | [NAME] | NLRTM PT | 40HC | USD | 700
NHAVA SHEVA | INNSA PT | [NAME] | NLRTM PT | 40HC | USD | 600
[NAME] | CNSNZ PT | [NAME] | NLRTM PT | 40HC | USD | 650
SHANGHAI | CNSGH PT | [NAME] | NLRTM PT | 40HC | USD | 650
FUZHOU | CNFZH PT | [NAME] | NLRTM PT | 40HC | USD | 750
SURABAYA | IDSUB PT | [NAME] | NLRTM PT | 40HC | USD | 650
MADRAS-CHENNAI | INMAA PT | [NAME] | NLRTM PT | 40HC | USD | 600
YANTIAN | CNYTN PT | [NAME] | NLRTM PT | 40HC | USD | 650
CHITTAGONG | BDCGP PT | [NAME] | NLRTM PT | 40HC | USD | 700
[NAME] | KHKOS PT | [NAME] | NLRTM PT | 40HC | USD | 975
RANGOON | MMRGN PT | [NAME] | NLRTM PT | 40HC | USD | 850
HAIPHONG | VNHPH PT | [NAME] | NLRTM PT | 40HC | USD | 750
KARACHI | PKKHI PT | [NAME] | NLRTM PT | 40HC | USD | 650
BANGKOK | THBKK PT | [NAME] | NLRTM PT | 40HC | USD | 700
WENZHOU | CNWZO PT | [NAME] | NLRTM PT | 40HC | USD | 850
JAKARTA | IDJKT PT | [NAME] | NLRTM PT | 40HC | USD | 650
QUINGDAO | CNQIN PT | [NAME] | NLRTM PT | 40HC | USD | 650
HONGKONG | HKHKG PT | [NAME] | NLRTM PT | 40HC | USD | 650
CHOCHIN | INCOK PT | [NAME] | NLRTM PT | 40HC | USD | 600