Spreadsheet: 159398d1338614722-excel-2007-data-validation-with-multiple-references-example
Sheet: Final Expense

Final Expense |  | American Continental |  | Age |  | Comm |  | Americo |  | Age |  | Comm |  | Foresters |  | Age |  | Comm |  | Forethought |  | Age |  | Comm |  | Laffeyette |  | Age |  | Comm |  | Madison National |  | Age |  | Comm |  | Monumental |  | Age |  | Comm |  | Royal Neighbors |  | Age |  | Comm |  | Sentinel |  |  | Age |  | Comm
American Continental |  | Level Benefit Plan |  | 45-80 | Level | 0.6 |  | Ultra Protector I |  | 50-75 | Level | 0.75 |  | Plan Right Level |  | 50-80 | Level | 0.7 |  | Forelife I |  | All | Level | 0.7 |  | Classic Protector Simple |  | 50-80 | Level | 0.7 |  | Level Benefit |  | 50-80 | Level | 0.7 |  |  |  | 50-80 | Pd-99 | 0.75 |  | Level |  | 50-80 |  | 0.7 |  | New Vantage I |  | Level | 0-75 |  | 0.65
Americo |  | Modified Benefit Plan |  | 81-85 |  | 0.45 |  | Ultra Protector II |  | 76-80 |  | 0.65 |  | Plan Right Modified |  | 81-85 |  | 0.4 |  |  |  |  |  |  |  | Classic Protector Graded |  | 81-85 |  | 0.49 |  | Graded Benefit |  | 81-85 |  | 0.4 |  |  |  | 81-85 | 10Pay | 0.55 |  |  |  | 81-85 |  | 0.45 |  |  |  |  | 76-80 |  | 0.65
Foresters |  |  |  | 86-89 |  | 0.25 |  |  |  | 81-85 |  | 0.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Classic Protector Single |  |  |  |  |  | Modified Benefit |  |  |  |  |  |  |  |  | Graded | 0.6 |  |  |  |  |  |  |  |  |  |  | 81-85 |  | 0.49
Forethought |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50-80 | Graded | 0.3 |  |  |  |  |  |  |  | Protector Single |  | 40-80 | Graded | 0.49 |  |  |  | 50-80 | Modified | 0.6 |  |  |  | 50-80 | AD& D Rdr | 0.6 |  | Graded |  | 50-80 |  | 0.45
Laffeyette |  |  |  | 45-75 | Modified | 0.33 |  |  |  | 50-70 | Graded | 0.7 |  |  |  |  |  |  |  |  |  |  |  |  |  | Protector 10 Pay |  | 81-85 |  | 0.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81-85 |  | 0.35 |  |  |  | 10 Pay |  |  | 0.65
Madison National |  |  |  |  |  |  |  |  |  | 71-80 |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Protector 5 Pay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 Pay |  |  | 0.65
Monumental |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30-70 | SPWL | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pd to 65 |  |  | 0.65
Royal Neighbors |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71-75 |  | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pd to 85 |  |  | 0.65
Sentinel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-80 |  | 0.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPWL | 20-69 |  | 0.045
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81-85 |  | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70-80 |  | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10Pay | 0.32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Vantage II |  | Graded | 45-75 |  | 0.62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5Pay | 0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-80 |  | 0.49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Vantage III |  | Modified | 45-75 |  | 0.41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-85 |  | 0.325
Monumental
Royal Neighbors | SImpleWL
50-80 |  | 0.7
81-85 |  | 0.45
 | Graded
50-80 |  | 0.45
81-85 |  | 0.35
Sentinel | Level
0-75 |  | 0.65
76-80 |  | 0.65
81-85 |  | 0.49
 | 10Pay | 0.65
 | 20Pay | 0.65
 | Pd-65 | 0.65
 | Pd-85 | 0.65
 | SpWL
20-69 |  | 0.045
70-80 |  | 0.018
 | Graded
45-75 |  | 0.62
76-85 |  | 0.49
 | Modified
45-75 |  | 0.41
76-85 |  | 0.325