Spreadsheet: 51126d1250686207-trying-to-match-data-in-different-columns-example
Sheet: Sheet1

Reporter | Partner | Fuel imports |  | Reporter | Partner | Total imports | Fuel imports
Argentina | Australia | 111641.201 |  | Argentina | Australia | 161852.863 | 111641.201
Argentina | Austria | 21.042 |  | Argentina | Austria | 151047.353 | 21.042
Argentina | Belgium | 15730.448 |  | Argentina | Belgium | 246217.389 | 15730.448
Argentina | Brazil | 350204.159 |  | Argentina | Brazil | 14660265.61 | 350204.159
Argentina | Bulgaria | 0.072 |  | Argentina | Bulgaria | 29445.766 | 0.072
Argentina | Canada | 3059.77 |  | Argentina | Canada | 292674.705 | 3059.77
Argentina | Chile | 45148.1 |  | Argentina | Chile | 708485.218 | 45148.1
Argentina | China | 13120.311 |  | Argentina | China | 5092953.61 | 13120.311
Argentina | Colombia | 35365.611 |  | Argentina | Colombia | 91018.381 | 35365.611
Argentina | Czech Rep | 136.802 |  | Argentina | Czech Rep | 63671.469 | 136.802
Argentina | Denmark | 41435.168 |  | Argentina | Dem.Rp.Congo | 0.014 | #N/A
Argentina | France+Monac | 23641.536 |  | Argentina | Denmark | 165149.704 | 41435.168
Argentina | Germany | 9493.225 |  | Argentina | Ethiopia | 5.649 | #N/A
Argentina | Greece | 18.561 |  | Argentina | Finland | 140435.246 | #N/A
Argentina | India | 1520.655 |  | Argentina | France+Monac | 1061116.918 | 23641.536
Argentina | Ireland | 0.013 |  | Argentina | Germany | 2131320.761 | 9493.225
Argentina | Israel | 0.385 |  | Argentina | Ghana | 0.004 | #N/A
Argentina | Italy | 21483.947 |  | Argentina | Greece | 7628.173 | 18.561
Argentina | Japan | 831.873 |  | Argentina | Hong Kong | 33507.132 | #N/A
Argentina | Korea Rep. | 1271.703 |  | Argentina | Hungary | 53809.421 | #N/A
Argentina | Malaysia | 596.156 |  | Argentina | India | 383716.143 | 1520.655
Argentina | Mexico | 80.438 |  | Argentina | Indonesia | 214165.383 | #N/A
Argentina | Netherlands | 32558.155 |  | Argentina | Iran-Islam.R | 1602.819 | #N/A
Argentina | New Zealand | 1.29 |  | Argentina | Ireland | 92941.128 | 0.013
Argentina | Norway,Sb,JM | 1.02 |  | Argentina | Israel | 125388.215 | 0.385
Argentina | Peru | 5.094 |  | Argentina | Italy | 1071382.251 | 21483.947
Argentina | Portugal | 4.059 |  | Argentina | Japan | 1200112.749 | 831.873
Argentina | Russian Fed | 54184.595 |  | Argentina | Kenya | 406.417 | #N/A
Argentina | South Africa | 37909.962 |  | Argentina | Korea Rep. | 525889.797 | 1271.703
Argentina | Spain | 22226.102 |  | Argentina | [NAME] | 1775.32 | #N/A
Argentina | Sweden | 12448.046 |  | Argentina | Malaysia | 325387.043 | 596.156
Argentina | Switz.Liecht | 28.337 |  | Argentina | Mexico | 1336578.617 | 80.438
Argentina | Taiwan | 79.088 |  | Argentina | Mozambique | 1303.745 | #N/A
Argentina | Thailand | 174.734 |  | Argentina | Netherlands | 236895.048 | 32558.155
Argentina | Turkey | 0.123 |  | Argentina | New Zealand | 14685.917 | 1.29
Argentina | Untd Arab Em | 12634.394 |  | Argentina | Nigeria | 613.034 | #N/A
Argentina | Untd.Kingdom | 6002.423 |  | Argentina | Norway,Sb,JM | 26982.102 | 1.02
Argentina | USA,PR,USVI | 347627.598 |  | Argentina | Pakistan | 45477.632 | #N/A
Argentina | Venezuela | 2830.191 |  | Argentina | Peru | 116019.582 | 5.094
Australia | Argentina | 6.596 |  | Argentina | Philippines | 47266.54 | #N/A
Australia | Australia | 46375.372 |  | Argentina | Poland | 107307.962 | #N/A
Australia | Austria | 24.699 |  | Argentina | Portugal | 86152.052 | 4.059
Australia | Belgium | 1836.013 |  | Argentina | Romania | 41766.056 | #N/A
Australia | Brazil | 351.319 |  | Argentina | Russian Fed | 430307.553 | 54184.595
Australia | Canada | 2170.899 |  | Argentina | Saudi Arabia | 23616.159 | #N/A
Australia | China | 49936.006 |  | Argentina | Sierra Leone | 169.018 | #N/A
Australia | Colombia | 374.885 |  | Argentina | Singapore | 126186.087 | #N/A
Australia | Denmark | 164.585 |  | Argentina | Slovakia | 25553.683 | #N/A
Australia | Finland | 113.516 |  | Argentina | Slovenia | 10889.562 | #N/A
Australia | France+Monac | 4073.808 |  | Argentina | South Africa | 131252.281 | 37909.962
Australia | Germany | 6518.398 |  | Argentina | Spain | 812646.267 | 22226.102
Australia | Greece | 25.657 |  | Argentina | Sudan | 162.647 | #N/A
Australia | Hong Kong | 157.099 |  | Argentina | Sweden | 315405.394 | 12448.046
Australia | Hungary | 102.366 |  | Argentina | Switz.Liecht | 288200.028 | 28.337
Australia | India | 4530.195 |  | Argentina | Taiwan | 330424.405 | 79.088
Australia | Indonesia | 1711953.006 |  | Argentina | Tanzania | 38.678 | #N/A
Australia | Iran-Islam.R | 72.423 |  | Argentina | Thailand | 456264.996 | 174.734
Australia | Ireland | 755.915 |  | Argentina | Turkey | 76423.305 | 0.123
Australia | Israel | 0.839 |  | Argentina | Ukraine | 118621.808 | #N/A
Australia | Italy | 1176.511 |  | Argentina | Untd Arab Em | 18021.31 | 12634.394
Australia | Japan | 440809.742 |  | Argentina | Untd.Kingdom | 445356.862 | 6002.423
Australia | Kenya | 1179.097 |  | Argentina | USA,PR,USVI | 5342303.578 | 347627.598
Australia | Korea Rep. | 312994.611 |  | Argentina | Venezuela | 23595.975 | 2830.191
Australia | Malaysia | 2105347.3 |  | Argentina | Viet Nam | 51731.44 | #N/A
Australia | Mozambique | 4.974 |  | Argentina | Zimbabwe | 43.518 | #N/A
Australia | Netherlands | 10271.212 |  | Australia | Argentina | 216047.974 | 6.596
Australia | New Zealand | 660406.024 |  | Australia | Australia | 621824.064 | 46375.372
Australia | Norway,Sb,JM | 24970.501 |  | Australia | Austria | 833850.565 | 24.699
Australia | Philippines | 178752.825 |  | Australia | Belgium | 1340686.227 | 1836.013
Australia | Poland | 717.985 |  | Australia | Brazil | 742743.544 | 351.319
Australia | Portugal | 5.809 |  | Australia | Bulgaria | 21668.584 | #N/A
Australia | Saudi Arabia | 617591.98 |  | Australia | Canada | 1688234.906 | 2170.899
Australia | Sierra Leone | 32.973 |  | Australia | Chile | 282648.445 | #N/A
Australia | Singapore | 4993383.035 |  | Australia | China | 24053871.144 | 49936.006
Australia | Slovenia | 26.551 |  | Australia | Colombia | 18619.12 | 374.885
Australia | South Africa | 5587.39 |  | Australia | Czech Rep | 188775.909 | #N/A
Australia | Spain | 1769.699 |  | Australia | Dem.Rp.Congo | 373.135 | #N/A
Australia | Sweden | 820.698 |  | Australia | Denmark | 815817.562 | 164.585
Australia | Switz.Liecht | 427.784 |  | Australia | Ethiopia | 3879.547 | #N/A
Australia | Taiwan | 461436.351 |  | Australia | Finland | 741668.911 | 113.516
Australia | Thailand | 140808.303 |  | Australia | France+Monac | 3880127.543 | 4073.808
Australia | Turkey | 5.627 |  | Australia | Germany | 8074256.92 | 6518.398
Australia | Untd Arab Em | 1621549.013 |  | Australia | Ghana | 6936.572 | #N/A
Australia | Untd.Kingdom | 4321.835 |  | Australia | Greece | 129578.018 | 25.657
Australia | USA,PR,USVI | 200599.833 |  | Australia | Hong Kong | 1162384.322 | 157.099
Australia | Viet Nam | 3019338.463 |  | Australia | Hungary | 274604.582 | 102.366
Austria | Australia | 6737.459 |  | Australia | India | 1209208.545 | 4530.195
Austria | Belgium | 108222.165 |  | Australia | Indonesia | 4048152.061 | 1711953.006
Austria | Brazil | 0.446 |  | Australia | Iran-Islam.R | 30200.688 | 72.423
Austria | Canada | 190.969 |  | Australia | Ireland | 1749438.75 | 755.915
Austria | Chile | 0.234 |  | Australia | Israel | 519346.636 | 0.839
Austria | China | 1859.749 |  | Australia | Italy | 4009107.643 | 1176.511
Austria | Czech Rep | 372544.261 |  | Australia | Japan | 14940695.739 | 440809.742
Austria | Denmark | 254.195 |  | Australia | Kenya | 12697.017 | 1179.097
Austria | Finland | 707.19 |  | Australia | Korea Rep. | 4938971.302 | 312994.611
Austria | France+Monac | 31803.284 |  | Australia | [NAME] | 6887.958 | #N/A
Austria | Germany | 5269576.766 |  | Australia | Malaysia | 6037588.163 | 2105347.3
Austria | Greece | 139.917 |  | Australia | Mexico | 938075.119 | #N/A
Austria | Hong Kong | 0.029 |  | Australia | Mozambique | 1402.263 | 4.974
Austria | Hungary | 499326.055 |  | Australia | Netherlands | 1208246.729 | 10271.212
Austria | India | 5.82 |  | Australia | New Zealand | 5186837.462 | 660406.024
Austria | Indonesia | 0.037 |  | Australia | Nigeria | 147.674 | #N/A
Austria | Iran-Islam.R | 268107.322 |  | Australia | Norway,Sb,JM | 339032.179 | 24970.501
Austria | Ireland | 169.908 |  | Australia | Pakistan | 126242.241 | #N/A
Austria | Israel | 0.044 |  | Australia | Peru | 112823.691 | #N/A
Austria | Italy | 460939.526 |  | Australia | Philippines | 661362.476 | 178752.825