Spreadsheet: 136658d1326766425-return-adjacent-column-from-opposite-column-nearest-closest-value-to-entered-string-costpermilepermpg
Sheet: COST per MILE per MPG 

LITRES | GALLONS | COST per LITRE | COST £ | [NAME] per TANK | MPG | COST PER MILE
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 100 | 7.8719723183391 | 0.7855019999999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 110 | 8.659169550173011 | 0.7140927272727272
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 115 | 9.052768166089965 | 0.6830452173913043
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 120 | 9.44636678200692 | 0.6545849999999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 125 | 9.839965397923876 | 0.6284015999999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 130 | 10.23356401384083 | 0.6042323076923076
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 135 | 10.62716262975779 | 0.5818533333333332 |  |  | MPG | 48
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 140 | 11.02076124567474 | 0.561072857142857
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 145 | 11.4143598615917 | 0.5417255172413792
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 150 | 11.80795847750865 | 0.5236679999999999 |  |  | [NAME] | 600
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 155 | 12.20155709342561 | 0.5067754838709677
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 160 | 12.59515570934256 | 0.4909387499999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 165 | 12.98875432525952 | 0.4760618181818181 |  |  | COST per LITRE | 1.359
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 170 | 13.38235294117647 | 0.4620599999999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 175 | 13.77595155709343 | 0.4488582857142857
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 180 | 14.16955017301038 | 0.4363899999999999 |  |  | JOURNEY COST
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 185 | 14.56314878892734 | 0.4245956756756756
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 190 | 14.95674740484429 | 0.4134221052631578
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 195 | 15.35034602076125 | 0.4028215384615384
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 200 | 15.7439446366782 | 0.392751
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 205 | 16.13754325259516 | 0.3831717073170731
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 210 | 16.53114186851211 | 0.3740485714285714
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 215 | 16.92474048442907 | 0.3653497674418604
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 220 | 17.31833910034602 | 0.3570463636363636
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 225 | 17.71193771626298 | 0.349112
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 230 | 18.10553633217993 | 0.3415226086956522
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 235 | 18.49913494809689 | 0.3342561702127659
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 240 | 18.89273356401384 | 0.3272924999999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 245 | 19.2863321799308 | 0.3206130612244897
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 250 | 19.67993079584775 | 0.3142007999999999
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 255 | 20.07352941176471 | 0.30804
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 260 | 20.46712802768166 | 0.3021161538461538
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 265 | 20.86072664359862 | 0.2964158490566037
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 270 | 21.25432525951557 | 0.2909266666666666
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 275 | 21.64792387543253 | 0.2856370909090909
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 280 | 22.04152249134948 | 0.2805364285714285
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 285 | 22.43512110726644 | 0.2756147368421052
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 290 | 22.82871972318339 | 0.2708627586206896
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 295 | 23.22231833910035 | 0.2662718644067796
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 300 | 23.6159169550173 | 0.261834
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 305 | 24.00951557093426 | 0.2575416393442623
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 310 | 24.40311418685121 | 0.2533877419354839
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 315 | 24.79671280276817 | 0.2493657142857142
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 320 | 25.19031141868512 | 0.245469375
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 325 | 25.58391003460208 | 0.2416929230769231
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 330 | 25.97750865051903 | 0.2380309090909091
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 335 | 26.37110726643599 | 0.2344782089552238
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 340 | 26.76470588235294 | 0.23103
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 345 | 27.1583044982699 | 0.2276817391304347
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 350 | 27.55190311418685 | 0.2244291428571428
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 355 | 27.94550173010381 | 0.2212681690140845
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 360 | 28.33910034602076 | 0.218195
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 365 | 28.73269896193772 | 0.2152060273972602
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 370 | 29.12629757785467 | 0.2122978378378378
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 375 | 29.51989619377163 | 0.2094672
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 380 | 29.91349480968858 | 0.2067110526315789
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 385 | 30.30709342560554 | 0.2040264935064935
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 390 | 30.70069204152249 | 0.2014107692307692
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 395 | 31.09429065743945 | 0.1988612658227848
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 400 | 31.4878892733564 | 0.1963755
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 405 | 31.88148788927336 | 0.1939511111111111
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 410 | 32.27508650519032 | 0.1915858536585366
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 415 | 32.66868512110727 | 0.1892775903614458
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 420 | 33.06228373702422 | 0.1870242857142857
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 425 | 33.45588235294118 | 0.184824
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 430 | 33.84948096885813 | 0.1826748837209302
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 435 | 34.24307958477509 | 0.1805751724137931
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 440 | 34.63667820069205 | 0.1785231818181818
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 445 | 35.030276816609 | 0.1765173033707865
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 450 | 35.42387543252595 | 0.174556
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 455 | 35.81747404844291 | 0.1726378021978022
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 460 | 36.21107266435986 | 0.1707613043478261
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 465 | 36.60467128027682 | 0.1689251612903226
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 470 | 36.99826989619378 | 0.167128085106383
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 475 | 37.39186851211073 | 0.1653688421052631
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 480 | 37.78546712802768 | 0.16364625
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 485 | 38.17906574394464 | 0.1619591752577319
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 490 | 38.57266435986159 | 0.1603065306122449
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 495 | 38.96626297577855 | 0.1586872727272727
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 500 | 39.35986159169551 | 0.1571004
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 505 | 39.75346020761246 | 0.1555449504950495
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 510 | 40.14705882352941 | 0.15402
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 515 | 40.54065743944637 | 0.1525246601941747
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 520 | 40.93425605536333 | 0.1510580769230769
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 525 | 41.32785467128028 | 0.1496194285714285
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 530 | 41.72145328719724 | 0.1482079245283019
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 535 | 42.11505190311419 | 0.1468228037383177
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 540 | 42.50865051903114 | 0.1454633333333333
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 545 | 42.9022491349481 | 0.1441288073394495
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 550 | 43.29584775086506 | 0.1428185454545454
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 555 | 43.68944636678201 | 0.1415318918918919
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 560 | 44.08304498269896 | 0.1402682142857143
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 565 | 44.47664359861592 | 0.1390269026548673
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 570 | 44.87024221453287 | 0.1378073684210526
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 575 | 45.26384083044983 | 0.1366090434782609
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 580 | 45.65743944636679 | 0.1354313793103448
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 585 | 46.05103806228374 | 0.1342738461538461
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 590 | 46.44463667820069 | 0.1331359322033898
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 595 | 46.83823529411765 | 0.1320171428571428
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 600 | 47.2318339100346 | 0.130917
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 605 | 47.62543252595156 | 0.129835041322314
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 610 | 48.01903114186852 | 0.1287708196721311
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 615 | 48.41262975778547 | 0.1277239024390244
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 620 | 48.80622837370242 | 0.1266938709677419
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 625 | 49.19982698961938 | 0.12568032
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 630 | 49.59342560553633 | 0.1246828571428571
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 635 | 49.98702422145329 | 0.1237011023622047
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 640 | 50.38062283737025 | 0.1227346875
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 645 | 50.7742214532872 | 0.1217832558139535
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 650 | 51.16782006920415 | 0.1208464615384615
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 655 | 51.56141868512111 | 0.1199239694656488
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 660 | 51.95501730103806 | 0.1190154545454545
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 665 | 52.34861591695502 | 0.1181206015037594
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 670 | 52.74221453287198 | 0.1172391044776119
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 675 | 53.13581314878893 | 0.1163706666666667
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 680 | 53.52941176470588 | 0.115515
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 685 | 53.92301038062284 | 0.1146718248175182
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 690 | 54.3166089965398 | 0.1138408695652174
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 695 | 54.71020761245675 | 0.1130218705035971
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 700 | 55.10380622837371 | 0.1122145714285714
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 705 | 55.49740484429066 | 0.1114187234042553
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 710 | 55.89100346020761 | 0.1106340845070422
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 715 | 56.28460207612457 | 0.1098604195804196
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 720 | 56.67820069204153 | 0.1090975
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 725 | 57.07179930795848 | 0.1083451034482758
57.8 | 12.7032967032967 | 1.359 | 78.55019999999999 | 730 | 57.46539792387544 | 0.1076030136986301