Spreadsheet: 880227d1727865143-number-not-found-using-match-or-vlookup-vlookup-jacc
Sheet: Local EBIT

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