Spreadsheet: 676804d1588975533-matching-data-and-copying-it-into-appropriate-cell-formula-test
Sheet: Sheet1

 |  | Medical Plan 1 |  |  |  |  | Plan 1
First Name | Age | Employee Rate | Employee Contribution | Employer Contribution |  |  | Ages | Rates
Employee 1 | 22 |  |  | 340.8 |  |  | 0-14 | 173
Employee 2 | 26 |  |  | 121.47 |  |  | 15 | 188.38
Employee 3 | 24 |  |  | 118.62 |  |  | 16 | 194.26
Employee 4 | 22 |  |  | 118.62 |  |  | 17 | 200.14
Employee 5 | 28 |  |  | 128.94 |  |  | 18 | 206.47
Employee 6 | 76 |  |  | 355.86 |  |  | 19 | 212.81
Employee 7 | 25 |  |  | 119.1 |  |  | 20 | 219.37
Employee 8 | 28 |  |  | 128.94 |  |  | 21 | 226.15
Employee 9 | 27 |  |  | 124.32 |  |  | 22 | 226.15
Employee 10 | 28 |  |  | 128.94 |  |  | 23 | 226.15
Employee 11 | 26 |  |  | 121.47 |  |  | 24 | 226.15
Employee 12 | 45 |  |  | 171.29 |  |  | 25 | 227.05
Employee 13 | 22 |  |  | 118.62 |  |  | 26 | 231.58
Employee 14 | 22 |  |  | 118.62 |  |  | 27 | 237.01
Employee 15 | 23 |  |  | 118.62 |  |  | 28 | 245.83
Employee 16 | 22 |  |  | 118.62 |  |  | 29 | 253.06
Employee 17 | 44 |  |  | 165.71 |  |  | 30 | 256.68
Employee 18 | 35 |  |  | 144.96 |  |  | 31 | 262.11
Employee 19 | 41 |  |  | 154.45 |  |  | 32 | 267.54
Employee 20 | 62 |  |  | 340.8 |  |  | 33 | 270.93
 |  |  |  |  |  |  | 34 | 274.55
 |  |  |  |  |  |  | 35 | 276.36
 |  |  |  |  |  |  | 36 | 278.16
 |  |  |  |  |  |  | 37 | 279.97
 |  |  |  |  |  |  | 38 | 281.78
 |  |  |  |  |  |  | 39 | 285.4
 |  |  |  |  |  |  | 40 | 289.02
 |  |  |  |  |  |  | 41 | 294.45
 |  |  |  |  |  |  | 42 | 299.65
 |  |  |  |  |  |  | 43 | 306.89
 |  |  |  |  |  |  | 44 | 315.93
 |  |  |  |  |  |  | 45 | 326.56
 |  |  |  |  |  |  | 46 | 339.23
 |  |  |  |  |  |  | 47 | 353.47
 |  |  |  |  |  |  | 48 | 369.76
 |  |  |  |  |  |  | 49 | 385.81
 |  |  |  |  |  |  | 50 | 403.9
 |  |  |  |  |  |  | 51 | 421.77
 |  |  |  |  |  |  | 52 | 441.44
 |  |  |  |  |  |  | 53 | 461.35
 |  |  |  |  |  |  | 54 | 482.83
 |  |  |  |  |  |  | 55 | 504.31
 |  |  |  |  |  |  | 56 | 527.61
 |  |  |  |  |  |  | 57 | 551.13
 |  |  |  |  |  |  | 58 | 576.23
 |  |  |  |  |  |  | 59 | 588.67
 |  |  |  |  |  |  | 60 | 613.77
 |  |  |  |  |  |  | 61 | 635.48
 |  |  |  |  |  |  | 62 | 649.73
 |  |  |  |  |  |  | 63 | 667.59
 |  |  |  |  |  |  | 64 | 678.45
 |  |  |  |  |  |  | 65 | 678.45
 |  |  |  |  |  |  | 66 | 678.45
 |  |  |  |  |  |  | 67 | 678.45
 |  |  |  |  |  |  | 68 | 678.45
 |  |  |  |  |  |  | 69 | 678.45
 |  |  |  |  |  |  | 70 | 678.45
 |  |  |  |  |  |  | 71 | 678.45
 |  |  |  |  |  |  | 72 | 678.45
 |  |  |  |  |  |  | 73 | 678.45
 |  |  |  |  |  |  | 74 | 678.45
 |  |  |  |  |  |  | 75 | 678.45
 |  |  |  |  |  |  | 76 | 678.45
 |  |  |  |  |  |  | 77 | 678.45
 |  |  |  |  |  |  | 78 | 678.45
 |  |  |  |  |  |  | 79 | 678.45
 |  |  |  |  |  |  | 80 | 678.45
 |  |  |  |  |  |  | 81 | 678.45
 |  |  |  |  |  |  | 82 | 678.45
 |  |  |  |  |  |  | 83 | 678.45
 |  |  |  |  |  |  | 84 | 678.45
 |  |  |  |  |  |  | 85 | 678.45
 |  |  |  |  |  |  | 86 | 678.45
 |  |  |  |  |  |  | 87 | 678.45
 |  |  |  |  |  |  | 88 | 678.45
 |  |  |  |  |  |  | 89 | 678.45
 |  |  |  |  |  |  | 90 | 678.45
 |  |  |  |  |  |  | 91 | 678.45
 |  |  |  |  |  |  | 92 | 678.45
 |  |  |  |  |  |  | 93 | 678.45
 |  |  |  |  |  |  | 94 | 678.45
 |  |  |  |  |  |  | 95 | 678.45
 |  |  |  |  |  |  | 96 | 678.45
 |  |  |  |  |  |  | 97 | 678.45
 |  |  |  |  |  |  | 98 | 678.45
 |  |  |  |  |  |  | 99 | 678.45
 |  |  |  |  |  |  | 100+ | 678.45