Spreadsheet: 807230d1669811476-vlookup-not-showing-correct-answer-broken
Sheet: Sheet1

0.54 | 74357 |  | 0.01
0.54 | 74357 |  | 0.05
0.61 | 76731 |  | 0.12
0.68 | 74357 |  | 0.13
0.72 | 70557 |  | 0.14
0.74 | 70362 |  | 0.15
0.77 | 74357 |  | 0.16
1.02 | 74374 |  | 0.17
1.02 | 76163 |  | 0.3
1.02 | 79048 |  | 0.32
1.02 | 75641 |  | 0.38
1.04 | 79145 |  | 0.4
1.04 | 76897 |  | 0.43
1.13 | 70500 |  | 0.44
1.19 | 74852 |  | 0.46
1.19 | 74852 |  | 0.47
1.50 | 76784 |  | 0.5
1.52 | 74694 |  | 0.61
1.55 | 75349 |  | 0.62
1.56 | 88774 |  | 0.67
1.56 | 76621 |  | 0.68
1.56 | 75075 |  | 0.69
2.12 | 70576 |  | 0.7
2.12 | 75114 |  | 0.71
2.14 | 75100 |  | 0.72
2.19 | 70553/74357 |  | 0.73
2.19 | 70588 |  | 0.74
2.19 | 70553 |  | 0.76
2.19 | 70553 |  | 0.78
2.20 | 74904 |  | 0.9
2.26 | 75057 |  | 0.91
2.27 | 70564 |  | 0.92
2.28 | 76118 |  | 1.02
2.29 | 75427 |  | 1.03
2.37 | 76344 |  | 1.04
2.38 | 70550 |  | 1.05
2.39 | 75656 |  | 1.06
2.40 | 75269 |  | 1.07
2.40 | 70560 |  | 1.08
2.40 | 76166 |  | 1.09
2.46 | 70549 |  | 1.11
2.46 | 70549 |  | 1.13
2.46 | 70504 |  | 1.17
2.47 | 70794 |  | 1.18
2.47 | 74096 |  | 1.19
2.47 | 76316 |  | 1.2
2.48 | 75665 |  | 1.21
2.48 | 75665 |  | 1.22
2.48 | 75665 |  | 1.23
2.48 | 75665 |  | 1.24
3.01 | 70134 |  | 1.25
3.03 | 70203 |  | 1.26
3.04 | 70502 |  | 1.27
3.04 | contact by email only |  | 1.28
3.07 | 76237 |  | 1.29
3.09 | 70118 |  | 1.3
3.10 | 70061 |  | 1.31
3.17 | 76356 |  | 1.32
3.17 | 76356 |  | 1.34
3.21 | 76317 |  | 1.35
3.22 | 70459 |  | 1.37
3.22 | 70459 |  | 1.38
3.23 | 70586 |  | 1.39 C,D,E,F,G,H,J,K
3.25 | 70205 |  | 1.4
3.28 | 75064 |  | 1.41
ROOM NUMBER | EXTENSION |  | 1.49
2.45 | 70233 |  | 1.5
2.40 | 70561 |  | 1.51
2.45 | 76988 |  | 1.52
2.40 | 70570 |  | 1.55
3.05 | 70247 |  | 1.56
0.77 | 74357 |  | 1.57
2.48 | 75665 |  | 2.01
0.75 | 74357 |  | 2.02
0.77 | 74357 |  | 2.03
2.30 | 70117 |  | 2.04
2.47 | 88773 |  | 2.05
1.51 | 76487 |  | 2.06
2.21 | 75063 |  | 2.08
2.73 | 76406 |  | 2.1
2.25 | 76522 |  | 2.11
0.77 | 74357 |  | 2.12
3.25 | 70205 |  | 2.13
2.10 | 70556 |  | 2.14
3.13 | 70202 |  | 2.15
3.13 | 70202 |  | 2.16
2.11 | 76471 |  | 2.17
1.18 | 79628 |  | 2.19
2.10 | 70556 |  | 2.2
2.11 | 76471 |  | 2.21
3.13 | 70202 |  | 2.22
2.11 | 76471 |  | 2.23
1.18 | 79628 |  | 2.24
3.13 | 70202 |  | 2.25
2.10 | 70556 |  | 2.26
2.10 | 70556 |  | 2.27
2.11 | 76471 |  | 2.28
1.18 | 79628 |  | 2.29
3.13 | 70202 |  | 2.3
2.10 | 70556 |  | 2.31
2.11 | 76474 |  | 2.32
2.11 | 76471 |  | 2.33
1.18 | 79628 |  | 2.34
1.18 | 79628 |  | 2.35
1.18 | 79628 |  | 2.36
2.11 | 76474 |  | 2.37
0.52 | 74357 |  | 2.38
2.11 | 76471 |  | 2.39
0.36 | 74357 |  | 2.4
2.10 | 70556 |  | 2.41
0.62 | 74357 |  | 2.43
0.52 | 74357 |  | 2.44
0.09 | 74357 |  | 2.45
1.18 | 79628 |  | 2.46
0.52 | 74357 |  | 2.47
0.52 | 74357 |  | 2.48
0.09 | 74357 |  | 2.49
0.36 | 74357 |  | 2.5
0.36 | 74357 |  | 2.51
0.09 | 74357 |  | 2.52
0.09 | 74357 |  | 2.53
0.09 | 74357 |  | 2.54
0.09 | 74357 |  | 2.57
0.52 | 74357 |  | 2.6
0.52 | 74357 |  | 2.61
0.09 | 74357 |  | 2.62
2.40 | 70561 |  | 2.64
2.40 | 70561 |  | 2.65
2.40 | 70561 |  | 2.66
2.40 | 70561 |  | 2.67
2.40 | 70561 |  | 2.68
2.40 | 70561 |  | 2.7
2.40 | 70561 |  | 2.71
2.40 | 70561 |  | 2.72
2.40 | 70561 |  | 2.73
2.40 | 70561 |  | 3.01
2.40 | 70561 |  | 3.02
2.40 | 70561 |  | 3.03
2.40 | 70561 |  | 3.04
2.40 | 70561 |  | 3.05
2.40 | 70561 |  | 3.06
2.40 | 70561 |  | 3.07
2.40 | 70561 |  | 3.08
2.40 | 70561 |  | 3.09
 |  |  | 3.1
 |  |  | 3.12
 |  |  | 3.13
 |  |  | 3.14
 |  |  | 3.16
 |  |  | 3.17
 |  |  | 3.18
 |  |  | 3.19
 |  |  | 3.2
 |  |  | 3.21
 |  |  | 3.22
 |  |  | 3.23
 |  |  | 3.24
 |  |  | 3.25
 |  |  | 3.26
 |  |  | 3.27
 |  |  | 3.28
 |  |  | 3.29
 |  |  | 3.3
 |  |  | 3.31
 |  |  | 0.04A
 |  |  | 0.04
 |  |  | 0.06A
 |  |  | 0.06B
 |  |  | 0.08A
 |  |  | 0.25A
 |  |  | 0.25B
 |  |  | 0.54-0.58
 |  |  | 0.79
 |  |  | 0.57
 |  |  | 0.64
 |  |  | 1.59
 |  |  | 1.60&1.73
 |  |  | 2Z.04