Spreadsheet: 713714d1610893175-look-up-using-two-pieces-of-criteria-but-need-the-nearest-match-multiple-criteria-vlookup-v2
Sheet: Sheet1

Group ID | Eff Date | Months From | Months To | Amount | Percentage |  |  |  | Group | Months | Amount | Expected
Group1 | 2016-01-01 00:00:00 | 0 | 1 | 0.833 | 0 |  |  |  | Group1 | 0.5 |  | 0.833
Group1 | 2016-01-01 00:00:00 | 0 | 2 | 1.666 | 0 |  |  |  | Group1 | 2 |  | 1.666 | Works fine
Group1 | 2016-01-01 00:00:00 | 0 | 3 | 2.499 | 0 |  |  |  | Group1 | 302 |  | 30
Group1 | 2016-01-01 00:00:00 | 0 | 4 | 3.332 | 0 |  |  |  | Group2 | 7.5 |  | 8.75 | Works fine
Group1 | 2016-01-01 00:00:00 | 0 | 5 | 4.165 | 0 |  |  |  | Group2 | 220 |  | 25
Group1 | 2016-01-01 00:00:00 | 0 | 6 | 4.998 | 0 |  |  |  | Group2 | 300 |  | 30
Group1 | 2016-01-01 00:00:00 | 0 | 7 | 5.831 | 0
Group1 | 2016-01-01 00:00:00 | 0 | 8 | 6.664 | 0
Group1 | 2016-01-01 00:00:00 | 0 | 9 | 7.497 | 0
Group1 | 2016-01-01 00:00:00 | 0 | 10 | 8.333 | 0
Group1 | 2016-01-01 00:00:00 | 0 | 11 | 9.163 | 0
Group1 | 2016-01-01 00:00:00 | 12 | 47 | 10 | 0
Group1 | 2016-01-01 00:00:00 | 48 | 119 | 15 | 0
Group1 | 2016-01-01 00:00:00 | 120 | 215 | 20 | 0
Group1 | 2016-01-01 00:00:00 | 216 | 299 | 25 | 0
Group1 | 2016-01-01 00:00:00 | 300 | 9999 | 30 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 1 | 1.25 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 2 | 2.5 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 3 | 3.75 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 4 | 5 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 5 | 6.25 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 6 | 7.5 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 7 | 8.75 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 8 | 10 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 9 | 11.25 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 10 | 12.5 | 0
Group2 | 2016-01-01 00:00:00 | 0 | 11 | 13.75 | 0
Group2 | 2016-01-01 00:00:00 | 12 | 119 | 15 | 0
Group2 | 2016-01-01 00:00:00 | 120 | 215 | 20 | 0
Group2 | 2016-01-01 00:00:00 | 216 | 299 | 25 | 0
Group2 | 2016-01-01 00:00:00 | 300 | 9999 | 30 | 0
Group3 | 2019-01-01 00:00:00 | 0 | 1 | 0.833 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 2 | 1.666 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 3 | 2.499 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 4 | 3.332 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 5 | 4.165 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 6 | 4.998 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 7 | 5.831 | 4
Group3 | 2019-01-01 00:00:00 | 0 | 8 | 6.664 | 4
Group3 | 2019-01-01 00:00:00 | 9 | 11 | 7.497 | 4
Group3 | 2019-01-01 00:00:00 | 12 | 35 | 10 | 4
Group3 | 2019-01-01 00:00:00 | 36 | 119 | 15 | 6
Group3 | 2019-01-01 00:00:00 | 120 | 215 | 20 | 8
Group3 | 2019-01-01 00:00:00 | 216 | 299 | 25 | 10
Group3 | 2019-01-01 00:00:00 | 300 | 99999 | 30 | 12
Group4 | 2016-12-16 00:00:00 | 0 | 1 | 1 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 2 | 2 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 3 | 3 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 4 | 4 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 5 | 5 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 6 | 6 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 7 | 7 | 4
Group4 | 2016-12-16 00:00:00 | 0 | 8 | 8 | 4
Group4 | 2016-12-16 00:00:00 | 9 | 11 | 9 | 4
Group4 | 2016-12-16 00:00:00 | 12 | 35 | 10 | 4
Group4 | 2016-12-16 00:00:00 | 36 | 119 | 15 | 6
Group4 | 2016-12-16 00:00:00 | 120 | 239 | 20 | 8
Group4 | 2016-12-16 00:00:00 | 240 | 359 | 25 | 10
Group4 | 2016-12-16 00:00:00 | 360 | 99999 | 30 | 12
Group5 | 2017-01-01 00:00:00 | 0 | 1 | 1 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 2 | 2 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 3 | 3 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 4 | 4 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 5 | 5 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 6 | 6 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 7 | 7 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 8 | 8 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 9 | 9 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 10 | 10 | 4
Group5 | 2017-01-01 00:00:00 | 0 | 11 | 10 | 4
Group5 | 2017-01-01 00:00:00 | 12 | 35 | 10 | 4
Group5 | 2017-01-01 00:00:00 | 36 | 95 | 15 | 6
Group5 | 2017-01-01 00:00:00 | 96 | 119 | 17 | 6.8
Group5 | 2017-01-01 00:00:00 | 120 | 191 | 20 | 8
Group5 | 2017-01-01 00:00:00 | 192 | 203 | 21 | 8.4
Group5 | 2017-01-01 00:00:00 | 204 | 215 | 22 | 8.8
Group5 | 2017-01-01 00:00:00 | 216 | 227 | 23 | 9.2
Group5 | 2017-01-01 00:00:00 | 228 | 239 | 24 | 9.6
Group5 | 2017-01-01 00:00:00 | 240 | 99999 | 25 | 10
Group6 | 2016-05-06 00:00:00 | 0 | 11 | 13 | 5.2
Group6 | 2016-05-06 00:00:00 | 12 | 35 | 13 | 5.2
Group6 | 2016-05-06 00:00:00 | 36 | 59 | 15 | 6
Group6 | 2016-05-06 00:00:00 | 60 | 119 | 20 | 8
Group6 | 2016-05-06 00:00:00 | 120 | 179 | 23 | 8
Group6 | 2016-05-06 00:00:00 | 180 | 239 | 25 | 8
Group6 | 2016-05-06 00:00:00 | 240 | 299 | 28 | 8
Group6 | 2016-05-06 00:00:00 | 300 | 359 | 30 | 8
Group6 | 2016-05-06 00:00:00 | 360 | 99999 | 32 | 8
Group7 | 2016-05-06 00:00:00 | 0 | 11 | 0 | 4
Group7 | 2016-05-06 00:00:00 | 12 | 35 | 10 | 4
Group7 | 2016-05-06 00:00:00 | 36 | 59 | 15 | 6
Group7 | 2016-05-06 00:00:00 | 60 | 119 | 17 | 7
Group7 | 2016-05-06 00:00:00 | 120 | 179 | 20 | 8
Group7 | 2016-05-06 00:00:00 | 180 | 239 | 22 | 9
Group7 | 2016-05-06 00:00:00 | 240 | 299 | 25 | 10
Group7 | 2016-05-06 00:00:00 | 300 | 359 | 27 | 11
Group7 | 2016-05-06 00:00:00 | 360 | 99999 | 30 | 12
Group8 | 2016-05-06 00:00:00 | 0 | 1 | 1 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 2 | 2 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 3 | 3 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 4 | 4 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 5 | 5 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 6 | 6 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 7 | 7 | 0
Group8 | 2016-05-06 00:00:00 | 0 | 8 | 8 | 0
Group8 | 2016-05-06 00:00:00 | 9 | 11 | 9 | 0
Group8 | 2016-05-06 00:00:00 | 12 | 35 | 10 | 0
Group8 | 2016-05-06 00:00:00 | 36 | 119 | 15 | 0
Group8 | 2016-05-06 00:00:00 | 120 | 239 | 20 | 0
Group8 | 2016-05-06 00:00:00 | 240 | 359 | 25 | 0
Group8 | 2016-05-06 00:00:00 | 360 | 99999 | 30 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 1 | 1 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 2 | 2 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 3 | 3 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 4 | 4 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 5 | 5 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 6 | 6 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 7 | 7 | 0
Group9 | 2016-05-06 00:00:00 | 0 | 8 | 8 | 0
Group9 | 2016-05-06 00:00:00 | 9 | 11 | 9 | 0
Group9 | 2016-05-06 00:00:00 | 12 | 47 | 10 | 0
Group9 | 2016-05-06 00:00:00 | 48 | 119 | 15 | 0
Group9 | 2016-05-06 00:00:00 | 120 | 239 | 20 | 0
Group9 | 2016-05-06 00:00:00 | 240 | 359 | 25 | 0
Group9 | 2016-05-06 00:00:00 | 360 | 99999 | 30 | 0