Spreadsheet: 884073d1732983609-cant-get-formula-if-choose-and-xlookup-to-work-together-formula-error-fixed-
Sheet: 2024

 |  |  | Medical Insurance
First Name | DOB | Age | Plan Number | Dependent? | TOTAL FAMILY RATE | Monthly Rate | Health Ins. Deduction |  | TOTAL Monthly Premium Effective: 01/01/2024 |  |  |  |  | Monthly PAYROLL DEDUCTIONS Effective : 01/01/2024
[NAME] | 1999-07-28 00:00:00 |  | 3 |  |  |  |  |  | Select Plus | CORE | Signature Value |  |  | Select Plus |  | CORE |  | Signature Value
[NAME] | 1977-04-03 00:00:00 |  | 1
Depdendent 1 | 1980-05-06 00:00:00 |  | 1 | Y |  |  |  |  | 1 | 2 | 3 | Age |  | Employee | Dependent | Employee | Dependent | Employee | Dependent | Age
Depdendent 2 | 2014-06-08 00:00:00 |  | 1 | Y |  |  |  |  | 371.43 | 348.95 | 358.3 | 0 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 0
Depdendent 3 | 2018-08-12 00:00:00 |  | 1 | Y |  |  |  |  | 371.43 | 348.95 | 358.3 | 1 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 1
Sue | 1981-10-17 00:00:00 |  | 2 |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 2 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 2
Sue | 1986-01-17 00:00:00 |  | 2 |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 3 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 3
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 4 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 4
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 5 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 5
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 6 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 6
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 7 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 7
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 8 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 8
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 9 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 9
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 10 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 10
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 11 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 11
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 12 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 12
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 13 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 13
 |  |  |  |  |  |  |  |  | 371.43 | 348.95 | 358.3 | 14 |  | 92.85750000000002 | 278.5725 | 87.23750000000001 | 261.7125 | 89.57499999999999 | 268.725 | 14
 |  |  |  |  |  |  |  |  | 404.45 | 379.96 | 390.15 | 15 |  | 101.1125 | 303.3375 | 94.99000000000001 | 284.97 | 97.53750000000002 | 292.6125 | 15
 |  |  |  |  |  |  |  |  | 417.07 | 391.82 | 402.33 | 16 |  | 104.2675 | 312.8025 | 97.95499999999998 | 293.865 | 100.5825 | 301.7475 | 16
 |  |  |  |  |  |  |  |  | 429.69 | 403.68 | 414.51 | 17 |  | 107.4225 | 322.2675 | 100.92 | 302.76 | 103.6275 | 310.8825 | 17
 |  |  |  |  |  |  |  |  | 443.29 | 416.46 | 427.62 | 18 |  | 110.8225 | 332.4675 | 104.115 | 312.345 | 106.905 | 320.715 | 18
 |  |  |  |  |  |  |  |  | 456.88 | 429.23 | 440.74 | 19 |  | 114.22 | 342.66 | 107.3075 | 321.9225 | 110.185 | 330.555 | 19
 |  |  |  |  |  |  |  |  | 470.96 | 442.46 | 454.32 | 20 |  | 117.74 | 353.22 | 110.615 | 331.845 | 113.58 | 340.74 | 20
 |  |  |  |  |  |  |  |  | 485.53 | 456.14 | 468.37 | 21 |  | 121.3825 | 364.1475 | 114.035 | 342.105 | 117.0925 | 351.2775 | 21
 |  |  |  |  |  |  |  |  | 485.53 | 456.14 | 468.37 | 22 |  | 121.3825 | 364.1475 | 114.035 | 342.105 | 117.0925 | 351.2775 | 22
 |  |  |  |  |  |  |  |  | 485.53 | 456.14 | 468.37 | 23 |  | 121.3825 | 364.1475 | 114.035 | 342.105 | 117.0925 | 351.2775 | 23
 |  |  |  |  |  |  |  |  | 485.53 | 456.14 | 468.37 | 24 |  | 121.3825 | 364.1475 | 114.035 | 342.105 | 117.0925 | 351.2775 | 24
 |  |  |  |  |  |  |  |  | 487.47 | 457.96 | 470.24 | 25 |  | 121.8675 | 365.6025 | 114.49 | 343.47 | 117.56 | 352.68 | 25
 |  |  |  |  |  |  |  |  | 497.18 | 467.09 | 479.61 | 26 |  | 124.295 | 372.885 | 116.7725 | 350.3175 | 119.9025 | 359.7075 | 26
 |  |  |  |  |  |  |  |  | 508.84 | 478.03 | 490.85 | 27 |  | 127.21 | 381.63 | 119.5075 | 358.5225 | 122.7125 | 368.1375 | 27
 |  |  |  |  |  |  |  |  | 527.77 | 495.82 | 509.12 | 28 |  | 131.9425 | 395.8275 | 123.955 | 371.865 | 127.28 | 381.84 | 28
 |  |  |  |  |  |  |  |  | 543.31 | 510.42 | 524.11 | 29 |  | 135.8275 | 407.4825 | 127.605 | 382.815 | 131.0275 | 393.0825 | 29
 |  |  |  |  |  |  |  |  | 551.08 | 517.72 | 531.6 | 30 |  | 137.77 | 413.3100000000001 | 129.43 | 388.29 | 132.9 | 398.7 | 30
 |  |  |  |  |  |  |  |  | 562.73 | 528.67 | 542.84 | 31 |  | 140.6825 | 422.0475 | 132.1675 | 396.5024999999999 | 135.71 | 407.13 | 31
 |  |  |  |  |  |  |  |  | 574.38 | 539.61 | 554.08 | 32 |  | 143.595 | 430.785 | 134.9025 | 404.7075 | 138.52 | 415.5600000000001 | 32
 |  |  |  |  |  |  |  |  | 581.66 | 546.46 | 561.11 | 33 |  | 145.415 | 436.245 | 136.615 | 409.845 | 140.2775 | 420.8325 | 33
 |  |  |  |  |  |  |  |  | 589.43 | 553.75 | 568.6 | 34 |  | 147.3575 | 442.0725 | 138.4375 | 415.3125 | 142.15 | 426.45 | 34
 |  |  |  |  |  |  |  |  | 593.32 | 557.4 | 572.35 | 35 |  | 148.33 | 444.99 | 139.35 | 418.05 | 143.0875 | 429.2625 | 35
 |  |  |  |  |  |  |  |  | 597.2 | 561.05 | 576.1 | 36 |  | 149.3 | 447.9 | 140.2625 | 420.7875 | 144.025 | 432.075 | 36
 |  |  |  |  |  |  |  |  | 601.09 | 564.7 | 579.84 | 37 |  | 150.2725 | 450.8175 | 141.175 | 423.525 | 144.96 | 434.88 | 37
 |  |  |  |  |  |  |  |  | 604.97 | 568.35 | 583.59 | 38 |  | 151.2425 | 453.7275 | 142.0875 | 426.2625 | 145.8975 | 437.6925 | 38
 |  |  |  |  |  |  |  |  | 612.74 | 575.65 | 591.08 | 39 |  | 153.185 | 459.555 | 143.9125 | 431.7375 | 147.77 | 443.3100000000001 | 39
 |  |  |  |  |  |  |  |  | 620.51 | 582.95 | 598.58 | 40 |  | 155.1275 | 465.3825 | 145.7375 | 437.2125 | 149.645 | 448.9350000000001 | 40
 |  |  |  |  |  |  |  |  | 632.16 | 593.89 | 609.82 | 41 |  | 158.04 | 474.12 | 148.4725 | 445.4175 | 152.455 | 457.365 | 41
 |  |  |  |  |  |  |  |  | 643.33 | 604.39 | 620.59 | 42 |  | 160.8325 | 482.4975000000001 | 151.0975 | 453.2925 | 155.1475 | 465.4425 | 42
 |  |  |  |  |  |  |  |  | 658.86 | 618.98 | 635.58 | 43 |  | 164.715 | 494.145 | 154.745 | 464.235 | 158.895 | 476.6850000000001 | 43
 |  |  |  |  |  |  |  |  | 678.29 | 637.23 | 654.31 | 44 |  | 169.5725 | 508.7175 | 159.3075 | 477.9225 | 163.5775 | 490.7325 | 44
 |  |  |  |  |  |  |  |  | 701.11 | 658.67 | 676.33 | 45 |  | 175.2775 | 525.8325 | 164.6675 | 494.0024999999999 | 169.0825 | 507.2475000000001 | 45
 |  |  |  |  |  |  |  |  | 728.3 | 684.21 | 702.56 | 46 |  | 182.075 | 546.2249999999999 | 171.0525 | 513.1575 | 175.64 | 526.92 | 46
 |  |  |  |  |  |  |  |  | 758.88 | 712.95 | 732.06 | 47 |  | 189.72 | 569.16 | 178.2375 | 534.7125000000001 | 183.015 | 549.045 | 47
 |  |  |  |  |  |  |  |  | 793.84 | 745.79 | 765.78 | 48 |  | 198.46 | 595.38 | 186.4475 | 559.3425 | 191.4449999999999 | 574.335 | 48
 |  |  |  |  |  |  |  |  | 828.31 | 778.17 | 799.04 | 49 |  | 207.0775 | 621.2325 | 194.5425 | 583.6274999999999 | 199.76 | 599.28 | 49
 |  |  |  |  |  |  |  |  | 867.16 | 814.67 | 836.51 | 50 |  | 216.79 | 650.37 | 203.6675 | 611.0024999999999 | 209.1275000000001 | 627.3824999999999 | 50
 |  |  |  |  |  |  |  |  | 905.51 | 850.7 | 873.51 | 51 |  | 226.3775000000001 | 679.1324999999999 | 212.675 | 638.0250000000001 | 218.3775000000001 | 655.1324999999999 | 51
 |  |  |  |  |  |  |  |  | 947.75 | 890.39 | 914.26 | 52 |  | 236.9375 | 710.8125 | 222.5975 | 667.7925 | 228.5650000000001 | 685.6949999999999 | 52
 |  |  |  |  |  |  |  |  | 990.48 | 930.53 | 955.47 | 53 |  | 247.62 | 742.86 | 232.6324999999999 | 697.8975 | 238.8675000000001 | 716.6025 | 53
 |  |  |  |  |  |  |  |  | 1036.61 | 973.86 | 999.97 | 54 |  | 259.1524999999999 | 777.4575 | 243.465 | 730.395 | 249.9925000000001 | 749.9775 | 54
 |  |  |  |  |  |  |  |  | 1082.73 | 1017.19 | 1044.47 | 55 |  | 270.6825 | 812.0475 | 254.2975 | 762.8925 | 261.1175000000001 | 783.3525 | 55
 |  |  |  |  |  |  |  |  | 1132.74 | 1064.17 | 1092.71 | 56 |  | 283.1849999999999 | 849.5550000000001 | 266.0425 | 798.1275 | 273.1775 | 819.5325 | 56
 |  |  |  |  |  |  |  |  | 1183.24 | 1111.61 | 1141.42 | 57 |  | 295.8099999999999 | 887.4300000000001 | 277.9024999999999 | 833.7075 | 285.355 | 856.065 | 57
 |  |  |  |  |  |  |  |  | 1237.13 | 1162.24 | 1193.41 | 58 |  | 309.2825 | 927.8475000000001 | 290.5599999999999 | 871.6800000000001 | 298.3525 | 895.0575000000001 | 58
 |  |  |  |  |  |  |  |  | 1263.83 | 1187.33 | 1219.17 | 59 |  | 315.9575 | 947.8725 | 296.8325 | 890.4975 | 304.7925 | 914.3775 | 59
 |  |  |  |  |  |  |  |  | 1317.73 | 1237.96 | 1271.16 | 60 |  | 329.4325 | 988.2975 | 309.49 | 928.47 | 317.79 | 953.3700000000001 | 60
 |  |  |  |  |  |  |  |  | 1364.34 | 1281.75 | 1316.12 | 61 |  | 341.085 | 1023.255 | 320.4375 | 961.3125 | 329.03 | 987.0899999999999 | 61
 |  |  |  |  |  |  |  |  | 1394.93 | 1310.49 | 1345.63 | 62 |  | 348.7325000000001 | 1046.1975 | 327.6224999999999 | 982.8675000000001 | 336.4075 | 1009.2225 | 62
 |  |  |  |  |  |  |  |  | 1433.28 | 1346.53 | 1382.63 | 63 |  | 358.3199999999999 | 1074.96 | 336.6324999999999 | 1009.8975 | 345.6575 | 1036.9725 | 63
 |  |  |  |  |  |  |  |  | 1456.59 | 1368.42 | 1405.11 | 64 |  | 364.1475 | 1092.4425 | 342.105 | 1026.315 | 351.2774999999999 | 1053.8325 | 64
 |  |  |  |  |  |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  | 65