Spreadsheet: 716284d1612153951-matching-multiple-criteria-where-one-of-the-them-needs-to-match-a-range-or-closest-value-title_billrate
Sheet: Table2_Reference

Ref_Standard Title | Ref_Standard Level | Ref_Market Grade | Ref_BillRates
Title_1 | I | .A+ | 45.9
Title_1 | I | A | 44.7
Title_1 | I | B | 42.65
Title_1 | I | C | 40.67
Title_1 | I | D | 38.7
Title_1 | II | .A+ | 63.03
Title_1 | II | A | 60.33
Title_1 | II | B | 54.35
Title_1 | II | C | 50.7
Title_1 | II | D | 48.02
Title_1 | III | .A+ | 72.95
Title_1 | III | A | 66.78
Title_1 | III | B | 62.12
Title_1 | III | C | 58.88
Title_1 | III | D | 56.17
Title_1 | IV | .A+ | 92.1328848
Title_1 | IV | A | 85.73268
Title_1 | IV | B | 82.22
Title_1 | IV | C | 72.34
Title_1 | IV | D | 69.72
Title_1 | V | .A+ | 106.88
Title_1 | V | A | 104.271304347826
Title_1 | V | B | 98.6672973913043
Title_1 | V | C | 95.3579347826087
Title_1 | V | D | 87.03
Title_2 | I | .A+ | 35.5
Title_2 | I | A | 33.32
Title_2 | I | B | 30.08
Title_2 | I | C | 29.26
Title_2 | I | D | 27.8
Title_2 | II | .A+ | 42.1014100094338
Title_2 | II | A | 38.2
Title_2 | II | B | 35.9
Title_2 | II | C | 34.6
Title_2 | II | D | 29.01
Title_2 | III | .A+ | 46.2957996475474
Title_2 | III | A | 45.3153358514054
Title_2 | III | B | 38.7504
Title_2 | III | C | 36.4
Title_2 | III | D | 34.98
Title_2 | IV | .A+ | 57.5
Title_2 | IV | A | 54.96
Title_2 | IV | B | 46.41975
Title_2 | IV | C | 43.7455392239459
Title_2 | IV | D | 40.02
Title_2 | V | .A+ | 62.92
Title_2 | V | A | 60.8
Title_2 | V | B | 51.87
Title_2 | V | C | 47.76
Title_2 | V | D | 43.79
Title_3 | I | .A+ | 90.11
Title_3 | I | A | 86.27
Title_3 | I | B | 85.91
Title_3 | I | C | 76.19
Title_3 | I | D | 70.37
Title_3 | II | .A+ | 101.583277019389
Title_3 | II | A | 95.12
Title_3 | II | B | 92.12
Title_3 | II | C | 89.26
Title_3 | II | D | 83.37
Title_3 | III | .A+ | 116.72
Title_3 | III | A | 108.66
Title_3 | III | B | 108.34
Title_3 | III | C | 101.08
Title_3 | III | D | 96.79
Title_3 | IV | .A+ | 132.05
Title_3 | IV | A | 122.7
Title_3 | IV | B | 119.06
Title_3 | IV | C | 111.08
Title_3 | IV | D | 107.23
Title_3 | V | .A+ | 148.97
Title_3 | V | A | 140.49
Title_3 | V | B | 137.09
Title_3 | V | C | 133.69
Title_3 | V | D | 129.78
Title_4 | I | .A+ | 74.02
Title_4 | I | A | 70.03
Title_4 | I | B | 64.55
Title_4 | I | C | 61.75
Title_4 | I | D | 57.03
Title_4 | II | .A+ | 86.48
Title_4 | II | A | 81.98
Title_4 | II | B | 75.38
Title_4 | II | C | 73.91
Title_4 | II | D | 66.12
Title_4 | III | .A+ | 103.91
Title_4 | III | A | 98.54
Title_4 | III | B | 90.28
Title_4 | III | C | 88.05
Title_4 | III | D | 85.23
Title_4 | IV | .A+ | 115.1
Title_4 | IV | A | 107.51
Title_4 | IV | B | 100.63
Title_4 | IV | C | 98.7
Title_4 | IV | D | 96.31
Title_4 | V | .A+ | 135.38
Title_4 | V | A | 130.07
Title_4 | V | B | 128.11
Title_4 | V | C | 120.09
Title_4 | V | D | 116.05
Title_5 | I | .A+ | 67.14
Title_5 | I | A | 65.87
Title_5 | I | B | 63.65
Title_5 | I | C | 58.067065
Title_5 | I | D | 53.99
Title_5 | II | .A+ | 79.44
Title_5 | II | A | 75.8
Title_5 | II | B | 72.38
Title_5 | II | C | 65.42
Title_5 | II | D | 59.87
Title_5 | III | .A+ | 96.77
Title_5 | III | A | 94.15
Title_5 | III | B | 81.44
Title_5 | III | C | 78.624
Title_5 | III | D | 65.01
Title_5 | IV | .A+ | 119.44
Title_5 | IV | A | 114.51
Title_5 | IV | B | 103.66
Title_5 | IV | C | 98.67
Title_5 | IV | D | 90.73
Title_5 | V | .A+ | 140.13
Title_5 | V | A | 135.03
Title_5 | V | B | 130.03
Title_5 | V | C | 109.87
Title_5 | V | D | 107.56
Title_6 | I | .A+ | 47.08
Title_6 | I | A | 43.78
Title_6 | I | B | 40.8
Title_6 | I | C | 37.95
Title_6 | I | D | 36.5
Title_6 | II | .A+ | 60.19
Title_6 | II | A | 52.34
Title_6 | II | B | 50.45
Title_6 | II | C | 46.56
Title_6 | II | D | 44.94
Title_6 | III | .A+ | 76.92
Title_6 | III | A | 70.54
Title_6 | III | B | 59.6
Title_6 | III | C | 56.9057349234409
Title_6 | III | D | 55.52
Title_6 | IV | .A+ | 90.33
Title_6 | IV | A | 86.3
Title_6 | IV | B | 82.67
Title_6 | IV | C | 75.25
Title_6 | IV | D | 71.55
Title_6 | V | .A+ | 118.908669801431
Title_6 | V | A | 99.298225642602
Title_6 | V | B | 97.91
Title_6 | V | C | 96.13
Title_6 | V | D | 89.97
Title_7 | I | .A+ | 79.38
Title_7 | I | A | 72.42
Title_7 | I | B | 66.59
Title_7 | I | C | 63.52
Title_7 | I | D | 60.78
Title_7 | II | .A+ | 100.11
Title_7 | II | A | 94.18
Title_7 | II | B | 92.12
Title_7 | II | C | 90.61
Title_7 | II | D | 87.94
Title_7 | III | .A+ | 114.28
Title_7 | III | A | 108.56
Title_7 | III | B | 105.78
Title_7 | III | C | 102.17
Title_7 | III | D | 99.38
Title_7 | IV | .A+ | 121.15
Title_7 | IV | A | 120.39
Title_7 | IV | B | 116.36
Title_7 | IV | C | 112.09
Title_7 | IV | D | 110.35
Title_7 | V | .A+ | 144.7
Title_7 | V | A | 142.02
Title_7 | V | B | 138.48
Title_7 | V | C | 129.56
Title_7 | V | D | 125.05
Title_8 | I | .A+ | 63.04
Title_8 | I | A | 60.52
Title_8 | I | B | 55.31
Title_8 | I | C | 53.29468
Title_8 | I | D | 50.26
Title_8 | II | .A+ | 73.5348272807611
Title_8 | II | A | 69.08
Title_8 | II | B | 66.11
Title_8 | II | C | 61.74
Title_8 | II | D | 59.13
Title_8 | III | .A+ | 90.72
Title_8 | III | A | 84.44
Title_8 | III | B | 82.11
Title_8 | III | C | 80.58
Title_8 | III | D | 78.89
Title_8 | IV | .A+ | 108.88
Title_8 | IV | A | 101.38
Title_8 | IV | B | 100.38
Title_8 | IV | C | 95.5
Title_8 | IV | D | 88.52
Title_8 | V | .A+ | 130.78
Title_8 | V | A | 128.86
Title_8 | V | B | 120.3
Title_8 | V | C | 119.06
Title_8 | V | D | 115.11
Title_9 | I | .A+ | 40.24
Title_9 | I | A | 38.81
Title_9 | I | B | 34.41
Title_9 | I | C | 29.12
Title_9 | I | D | 27.22
Title_9 | II | .A+ | 46.74
Title_9 | II | A | 43.81
Title_9 | II | B | 39.59
Title_9 | II | C | 36.66
Title_9 | II | D | 33.04
Title_9 | III | .A+ | 51.46
Title_9 | III | A | 50.09
Title_9 | III | B | 45.26
Title_9 | III | C | 43.66
Title_9 | III | D | 40.82
Title_9 | IV | .A+ | 57.26
Title_9 | IV | A | 55.34
Title_9 | IV | B | 51.29
Title_9 | IV | C | 50.86
Title_9 | IV | D | 47.13
Title_9 | V | .A+ | 70.56
Title_9 | V | A | 68.05
Title_9 | V | B | 65.26
Title_9 | V | C | 64.7
Title_9 | V | D | 62.75