Spreadsheet: 96529d1295912042-if-and-with-vlookup-with-multiple-criterias-test-1-
Sheet: Rates

 | Level A Employees |  |  |  |  |  |  |  |  |  |  |  | Class | Cigna Level A | BCBS Plans | Cigna Tier | [NAME]
 |  | Level 1 - Plan T30 |  |  | Level 2 - Plan T31 |  |  | Level 3 - Plan T32 |  |  |  |  | Level A | Plan T30 | RM17 | Employee Only | Employee Only
 | MEDICAL RATES | Monthly Cost | Employer Cost | Employee Cost | Monthly Cost | Employer Cost | Employee Cost | Monthly Cost | Employer Cost | Employee Cost |  |  | Level B | Plan T31 | RM09 | Employee + 1 | Employee + Spouse
 | Employee Only | 49.7 | 39.76 | 9.94 | 101.57 | 81.26 | 20.31 | 155.44 | 81.26 | 74.18 |  |  | Level C | Plan T32 | RM17 | Employee + Family | Employee + Child(ren)
 | Employee + 1 | 122.02 | 39.76 | 82.26 | 249.21 | 81.26 | 167.95 | 381.07 | 81.26 | 299.81 |  |  | Level D |  | RM09 | Employee Only | Employee + Family
 | Employee + Family | 184.38 | 39.76 | 144.62 | 376.44 | 81.26 | 295.18 | 575.64 | 81.26 | 494.38 |  |  |  |  | RM17 | Employee + 1 | Employee Only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RM09 | Employee + Family | Employee + Spouse
 | Level B Employees |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Only | Employee + Child(ren)
 |  | RM17 |  |  | RM09 |  |  |  |  |  |  |  |  |  |  | Employee + 1 | Employee + Family
 | MEDICAL RATES | Monthly Cost | Employer Cost | Employee Cost | Monthly Cost | Employer Cost | Employee Cost |  |  |  |  |  |  |  |  | Employee + Family
 | Employee Only | 465.51 | 372.41 | 93.09999999999997 | 524.22 | 372.41 | 151.81
 | Employee + Spouse | 978.57 | 372.41 | 606.1600000000001 | 1102 | 372.41 | 729.5899999999999
 | Employee + Child(ren) | 801.47 | 372.41 | 429.06 | 902.56 | 372.41 | 530.1499999999999
 | Employee + Family | 1406.63 | 372.41 | 1034.22 | 1584.04 | 372.41 | 1211.63
 | Level C Employees
 |  | RM17 |  |  | RM09
 | MEDICAL RATES | Monthly Cost | Employer Cost | Employee Cost | Monthly Cost | Employer Cost | Employee Cost
 | Employee Only | 465.51 | 372.41 | 93.1 | 524.22 | 372.41 | 151.81
 | Employee + Spouse | 978.57 | 587.14 | 391.43 | 1102 | 587.14 | 514.86
 | Employee + Child(ren) | 801.47 | 480.88 | 320.59 | 902.56 | 480.88 | 421.68
 | Employee + Family | 1406.63 | 843.98 | 562.65 | 1584.04 | 843.98 | 740.06
 | Level D Employees
 |  | RM17 |  |  | RM09
 | MEDICAL RATES | Monthly Cost | Employer Cost | Employee Cost | Monthly Cost | Employer Cost | Employee Cost
 | Employee Only | 465.51 | 372.41 | 93.1 | 524.22 | 372.41 | 151.81
 | Employee + Spouse | 978.57 | 587.14 | 391.43 | 1102 | 587.14 | 514.86
 | Employee + Child(ren) | 801.47 | 480.88 | 320.59 | 902.56 | 480.88 | 421.68
 | Employee + Family | 1406.63 | 843.98 | 562.65 | 1584.04 | 843.98 | 740.06
 | DENTAL RATES |  |  |  |  | VOLUNTARY LIFE |  |  | VOLUNTARY AD&D
 | Employee Only | 29.1 |  |  |  | Age | Employee |  | Employee | 0.04
 | Employee + Spouse | 57.85 |  |  |  | 0 | 0.07 |  | Family | 0.06
 | Employee + Child(ren) | 68.74 |  |  |  | 20 | 0.07
 | Employee + Family | 97.48 |  |  |  | 25 | 0.07 |  | VOLUNTARY CHILD LIFE RATES
 |  |  |  |  |  | 30 | 0.09 |  | 10000 | 2
 |  |  |  |  |  | 35 | 0.11
 | VISION  RATES |  |  |  |  | 40 | 0.17
 | Employee Only | 5.96 |  |  |  | 45 | 0.27 |  | Basic Life and AD&D Reductions
 | Employee + Spouse | 11.32 |  |  |  | 50 | 0.42 |  | Age | Reduce To
 | Employee + Child(ren) | 11.92 |  |  |  | 55 | 0.68 |  | 0 | 1
 | Employee + Family | 17.52 |  |  |  | 60 | 1.06 |  | 65 | 0.65
 |  |  |  |  |  | 65 | 1.69 |  | 70 | 0.5
 |  |  |  |  |  | 70 | 2.66 |  | 75 | 0.5
 | PREMIUM SAVER RATES |  |  |  |  | 75 | 4.73 |  | 80 | 0.5
 |  | Option #1 | Option #2 |  |  | 80 | 4.73 |  | 85 | 0.5
 | Employee Only | 41.65 | 64.07 |  |  | 85 | 4.73
 | Employee + Spouse | 90.02 | 140.15 |  |  | 90 | 4.73
 | Employee + Child(ren) | 76.36 | 123.52 |  |  | 95 | 4.73
 | Employee + Family | 122.62 | 198.34
 | BASIC LIFE & AD&D RATES
 |  | LIFE | AD&D
 | Employee | 0.15 | 0.02
 | STD RATES
 |  | Rate | Percentage | [NAME] | [NAME] Salary
 | STD | 0.19 | 0.6 | 1000 | 1666.666666666667
 | LTD RATES
 |  | Rate | Percentage | [NAME] | [NAME] Salary
 | LTD | 0.24 | 0.6 | 8500 | 14166.66666666667