Spreadsheet: 880216d1727856599-number-not-found-using-match-or-vlookup-vlookup
Sheet: Local EBIT

Lookup value | result
0.1 | 0.004761904761904762 | 19.1
0.2 | 0.009523809523809525 | 19.2
0.3 | 0.01428571428571429
0.4 | 0.01904761904761905
0.5 | 0.02380952380952381
0.6 | 0.02857142857142857
0.7 | 0.03333333333333333
0.7999999999999999 | 0.03809523809523809
0.8999999999999999 | 0.04285714285714285
0.9999999999999999 | 0.04761904761904762
1.1 | 0.05238095238095238
1.2 | 0.05714285714285714
1.3 | 0.06190476190476191
1.4 | 0.06666666666666668
1.5 | 0.07142857142857144
1.6 | 0.07619047619047621
1.7 | 0.08095238095238097
1.8 | 0.08571428571428574
1.900000000000001 | 0.0904761904761905
2 | 0.09523809523809526
2.100000000000001 | 0.1
2.200000000000001 | 0.1047619047619048
2.300000000000001 | 0.1095238095238096
2.400000000000001 | 0.1142857142857143
2.500000000000001 | 0.1190476190476191
2.600000000000001 | 0.1238095238095239
2.700000000000001 | 0.1285714285714286
2.800000000000001 | 0.1333333333333334
2.900000000000001 | 0.1380952380952382
3.000000000000001 | 0.1428571428571429
3.100000000000001 | 0.1476190476190477
3.200000000000002 | 0.1523809523809525
3.300000000000002 | 0.1571428571428572
3.400000000000002 | 0.161904761904762
3.500000000000002 | 0.1666666666666667
3.600000000000002 | 0.1714285714285715
3.700000000000002 | 0.1761904761904763
3.800000000000002 | 0.1809523809523811
3.900000000000002 | 0.1857142857142858
4.000000000000002 | 0.1904761904761905
4.100000000000001 | 0.1952380952380953
4.200000000000001 | 0.2
4.300000000000001 | 0.2047619047619048
4.4 | 0.2095238095238095
4.5 | 0.2142857142857143
4.6 | 0.219047619047619
4.699999999999999 | 0.2238095238095238
4.799999999999999 | 0.2285714285714285
4.899999999999999 | 0.2333333333333333
4.999999999999998 | 0.238095238095238
5.099999999999998 | 0.2428571428571427
5.199999999999998 | 0.2476190476190475
5.299999999999997 | 0.2523809523809523
5.399999999999997 | 0.257142857142857
5.499999999999996 | 0.2619047619047618
5.599999999999996 | 0.2666666666666665
5.699999999999996 | 0.2714285714285712
5.799999999999995 | 0.276190476190476
5.899999999999995 | 0.2809523809523807
5.999999999999995 | 0.2857142857142855
6.099999999999994 | 0.2904761904761902
6.199999999999994 | 0.295238095238095
6.299999999999994 | 0.2999999999999997
6.399999999999993 | 0.3047619047619045
6.499999999999993 | 0.3095238095238092
6.599999999999993 | 0.3142857142857139
6.699999999999992 | 0.3190476190476187
6.799999999999992 | 0.3238095238095234
6.899999999999991 | 0.3285714285714282
6.999999999999991 | 0.3333333333333329
7.099999999999991 | 0.3380952380952377
7.19999999999999 | 0.3428571428571424
7.29999999999999 | 0.3476190476190472
7.39999999999999 | 0.3523809523809519
7.499999999999989 | 0.3571428571428567
7.599999999999989 | 0.3619047619047614
7.699999999999989 | 0.3666666666666661
7.799999999999988 | 0.3714285714285709
7.899999999999988 | 0.3761904761904756
7.999999999999988 | 0.3809523809523804
8.099999999999987 | 0.3857142857142851
8.199999999999987 | 0.3904761904761899
8.299999999999986 | 0.3952380952380946
8.399999999999986 | 0.3999999999999994
8.499999999999986 | 0.4047619047619041
8.599999999999985 | 0.4095238095238088
8.699999999999985 | 0.4142857142857136
8.799999999999985 | 0.4190476190476183
8.899999999999984 | 0.4238095238095231
8.999999999999984 | 0.4285714285714278
9.099999999999984 | 0.4333333333333326
9.199999999999983 | 0.4380952380952373
9.299999999999983 | 0.4428571428571421
9.399999999999983 | 0.4476190476190468
9.499999999999982 | 0.4523809523809516
9.599999999999982 | 0.4571428571428563
9.699999999999982 | 0.461904761904761
9.799999999999981 | 0.4666666666666658
9.89999999999998 | 0.4714285714285705
9.99999999999998 | 0.4761904761904753
10.09999999999998 | 0.48095238095238
10.19999999999998 | 0.4857142857142848
10.29999999999998 | 0.4904761904761895
10.39999999999998 | 0.4952380952380943
10.49999999999998 | 0.499999999999999
10.59999999999998 | 0.5047619047619037
10.69999999999998 | 0.5095238095238085
10.79999999999998 | 0.5142857142857132
10.89999999999998 | 0.519047619047618
10.99999999999998 | 0.5238095238095227
11.09999999999998 | 0.5285714285714275
11.19999999999998 | 0.5333333333333322
11.29999999999998 | 0.538095238095237
11.39999999999998 | 0.5428571428571417
11.49999999999998 | 0.5476190476190465
11.59999999999997 | 0.5523809523809512
11.69999999999997 | 0.5571428571428559
11.79999999999997 | 0.5619047619047607
11.89999999999997 | 0.5666666666666654
11.99999999999997 | 0.5714285714285702
12.09999999999997 | 0.5761904761904749
12.19999999999997 | 0.5809523809523797
12.29999999999997 | 0.5857142857142844
12.39999999999997 | 0.5904761904761892
12.49999999999997 | 0.5952380952380939
12.59999999999997 | 0.5999999999999986
12.69999999999997 | 0.6047619047619034
12.79999999999997 | 0.6095238095238081
12.89999999999997 | 0.6142857142857129
12.99999999999997 | 0.6190476190476176
13.09999999999997 | 0.6238095238095224
13.19999999999997 | 0.6285714285714271
13.29999999999997 | 0.6333333333333319
13.39999999999997 | 0.6380952380952366
13.49999999999997 | 0.6428571428571414
13.59999999999997 | 0.6476190476190461
13.69999999999997 | 0.6523809523809508
13.79999999999997 | 0.6571428571428556
13.89999999999997 | 0.6619047619047603
13.99999999999997 | 0.6666666666666651
14.09999999999997 | 0.6714285714285698
14.19999999999997 | 0.6761904761904746
14.29999999999997 | 0.6809523809523793
14.39999999999996 | 0.685714285714284
14.49999999999996 | 0.6904761904761888
14.59999999999996 | 0.6952380952380935
14.69999999999996 | 0.6999999999999983
14.79999999999996 | 0.704761904761903
14.89999999999996 | 0.7095238095238078
14.99999999999996 | 0.7142857142857125
15.09999999999996 | 0.7190476190476173
15.19999999999996 | 0.723809523809522
15.29999999999996 | 0.7285714285714268
15.39999999999996 | 0.7333333333333315
15.49999999999996 | 0.7380952380952363
15.59999999999996 | 0.742857142857141
15.69999999999996 | 0.7476190476190457
15.79999999999996 | 0.7523809523809505
15.89999999999996 | 0.7571428571428552
15.99999999999996 | 0.76190476190476
16.09999999999996 | 0.7666666666666647
16.19999999999996 | 0.7714285714285696
16.29999999999996 | 0.7761904761904743
16.39999999999996 | 0.7809523809523792
16.49999999999996 | 0.785714285714284
16.59999999999997 | 0.7904761904761889
16.69999999999997 | 0.7952380952380936
16.79999999999997 | 0.7999999999999985
16.89999999999997 | 0.8047619047619033
16.99999999999997 | 0.8095238095238082
17.09999999999997 | 0.814285714285713
17.19999999999997 | 0.8190476190476178
17.29999999999998 | 0.8238095238095227
17.39999999999998 | 0.8285714285714275
17.49999999999998 | 0.8333333333333324
17.59999999999998 | 0.8380952380952371
17.69999999999998 | 0.842857142857142
17.79999999999998 | 0.8476190476190468
17.89999999999998 | 0.8523809523809517
17.99999999999999 | 0.8571428571428564
18.09999999999999 | 0.8619047619047613
18.19999999999999 | 0.8666666666666661
18.29999999999999 | 0.871428571428571
18.39999999999999 | 0.8761904761904757
18.49999999999999 | 0.8809523809523806
18.59999999999999 | 0.8857142857142855
18.7 | 0.8904761904761903
18.8 | 0.895238095238095
18.9 | 0.8999999999999999
19 | 0.9047619047619048
19.1 | 0.9095238095238096
19.2 | 0.9142857142857144
19.3 | 0.9190476190476192
19.40000000000001 | 0.9238095238095241
19.50000000000001 | 0.9285714285714289
19.60000000000001 | 0.9333333333333338
19.70000000000001 | 0.9380952380952385
19.80000000000001 | 0.9428571428571434
19.90000000000001 | 0.9476190476190482
20.00000000000001 | 0.9523809523809531
20.10000000000002 | 0.9571428571428579
20.20000000000002 | 0.9619047619047627
20.30000000000002 | 0.9666666666666676
20.40000000000002 | 0.9714285714285724
20.50000000000002 | 0.9761904761904772
20.60000000000002 | 0.980952380952382
20.70000000000002 | 0.9857142857142869
20.80000000000003 | 0.9904761904761917
20.90000000000003 | 0.9952380952380965
21.00000000000003 | 1.000000000000001