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

Annuity
 |  | Allianz | Plan | Age | Comm |  | American Equity | Plan | Age | Comm |  | Americo | Plan | Age | Comm |  | Aviva | Plan | Age | Comm |  | Equitrust | Plan | Age | Comm |  | Forethought | Plan | Age | Comm |  | Fideleity & Guarantee | Plan | Age | Comm |  | Great American | Plan | Age | Comm |  | Life of the Southwest | Plan | Age | Comm |  | National Western | Plan | Age | Comm |  | North American Company | Plan | Age | Comm |  | One America | Plan | Age | Comm |  | Royal Neighbors | Plan | Age | Comm
Allianz |  |  | Immediate Elite | 0-100 | 0.009 |  |  | Advantage Gold | 0-75 | 0.035 |  |  | Ultimate One Index 9yr no Bonus | 0-80 | 0.06 |  |  | Income Prefered 6 | 0-75 | 0.021 |  |  | Market 12 Bonus | 0-75 | 0.0514 |  |  | Bonus Advantage | 55-75 | 0.045 |  |  | MYGA 3 | All
American Equity |  |  | Command Provider | 0-75 | 0.011 |  |  |  | 76-80 | 0.0235 |  |  |  | 81-85 | 0.04 |  |  |  | 76-80 | 0.012 |  |  | Market Power Bonus | 0-75 | 0.0482 |  |  |  | 76-80 | 0.0305 |  |  | MYGA 5 | All
Americo |  |  |  | 76-85 | 0.011 |  |  | Integrity Gold | 0-75 | 0.02 |  |  | Ultimate One Index 9yr w/ Bonus | 0-80 | 0.06 |  |  | Income Prefered 10 | 0-75 | 0.048 |  |  | Market Booster | 0-75 | 0.0321 |  |  | Bonus Advantage WA | 55-75 | 0.0386 |  |  | Guarantee Platinum 3 | 0-79
Aviva |  |  | MasterDex Plus | 0-75 | 0.035 |  |  |  | 76-80 | 0.0119 |  |  |  |  |  |  |  |  | 76-78 | 0.028 |  |  | Maket Value | 0-75 | 0.0354 |  |  |  | 76-80 | 0.024 |  |  |  | 80-90
Great American |  |  |  | 76-80 | 0.0288 |  |  | Retirement Gold | 0-78 | 0.035 |  |  | Ultimate One Index 7yr | 0-80 | 0.04 |  |  | Income Prefered Ultimate | 0-75 | 0.048 |  |  | Market 7 | 0-75 | 0.0289 |  |  | Secure Bonus 115 Plus | 0-75 | 0.045 |  |  | Guarantee Platinum 5 | 0-79
Life of the Southwest |  |  | MasterDex 5 Plus | 0-75 | 0.0405 |  |  | Retirement Gold OR | 0-78 | 0.0305 |  |  |  | 81-85 | 0.02 |  |  |  | 76-78 | 0.028 |  |  | Market 10 Bonus | 0-75 | 0.0305 |  |  |  | 76-85 | 0.029 |  |  |  | 80-90
National Western |  |  |  | 76-80 | 0.0288 |  |  | Bonus Gold | 0-75 | 0.035 |  |  | Future Provider no Bonus | 0-80 | 0.0525 |  |  | Income Prefered Bonus | 0-75 | 0.04 |  |  | Builder Bonus Index | 0-75 | 0.305 |  |  | Secure Bonus 115 Plus OR | 0-75 | 0.0386 |  |  | Guarantee Platinum 7 | 0-79
North American Company |  |  | MasterDex 10 Plus | 0-75 | 0.0405 |  |  |  | 76-80 | 0.0235 |  |  |  | 81-85 | 0.035 |  |  |  | 76-78 | 0.0265 |  |  | Confidence Income 5-9 | 0-75 | 0.008 |  |  |  | 76-85 | 0.0225 |  |  |  | 80-90
One America |  |  |  | 76-80 | 0.0288 |  |  | 10/10 Gold | 0-75 | 0.035 |  |  |  | 86-90 | 0.0125 |  |  | Income Prefered Bonus S | 0-75 | 0.032 |  |  | Confidence Income 10-20 + Life | 0-75 | 0.0096 |  |  | Secure Bonus 115 | 0-75 | 0.045 |  |  | Guarantee Plus 7 | 0-79
Royal Neighbors |  |  | MasterDex X | 0-75 | 0.0405 |  |  |  | 76-80 | 0.0235 |  |  | Future Provider W/ Bonus | 0-80 | 0.0325 |  |  |  | 76-78 | 0.0205 |  |  | Choice 4 | 0-80 | 0.0273 |  |  |  | 76-85 | 0.029 |  |  |  | 80-90
 |  |  |  | 76-80 | 0.0288 |  |  | Benefit Gold | 0-75 | 0.027 |  |  |  | 81-85 | 0.02 |  |  | Income Prefered Bonus Pro | 65-75 | 0.034 |  |  |  | 81-85 | 0.0161 |  |  | Secure Bonus 115 OR | 0-75 | 0.0386 |  |  | Guarantee Plus 3 | 0-79
 |  |  | Dominator Plus 5 yr GIR | 0-75 | 0.009 |  |  |  | 76-80 | 0.0183 |  |  | Elite Provider | 0-75 | 0.05 |  |  |  | 76-78 | 0.021 |  |  | Certainty | 0-80 | 0.0096 |  |  |  | 76-85 | 0.0225 |  |  |  | 80-90
 |  |  |  | 76-80 | 0.0065 |  |  | Guarantee 5 | 0-75 | 0.0081 |  |  |  | 76-80 | 0.025 |  |  | Income Select Bonus | 0-75 | 0.031 |  |  |  | 81-85 | 0.0084 |  |  | Index Bonus 115 | 0-75 | 0.0513 |  |  | Guarantee Plus 5 | 0-79
 |  |  |  | 81-85 | 0.0032 |  |  |  | 76-80 | 0.005 |  |  |  | 81-85 | 0.015 |  |  |  | 76-78 | 0.0195 |  |  | Certainty Select | 0-80 | 0.0096 |  |  |  | 76-85 | 0.0352 |  |  |  | 80-90
 |  |  | Dominator Plus 10 yr GIR | 0-75 | 0.0175 |  |  | Guarantee 7 | 0-75 | 0.0081 |  |  | Elite Provider OR | 0-75 | 0.035 |  |  | Income Select Platinum | 0-75 | 0.0195 |  |  |  | 81-85 | 0.0084 |  |  | Index Bonus 115 Plus OR | 0-75 | 0.045 |  |  | Immediate Safeguard | All
 |  |  |  | 76-80 | 0.009 |  |  |  | 76-80 | 0.005 |  |  |  | 76-80 | 0.0175 |  |  |  | 76-78 | 0.007 |  |  |  |  |  |  |  |  | 76-85 | 0.029 |  |  | Immediate Income | 0-89
 |  |  |  | 81-85 | 0.0065 |  |  | Guarantee 5 w/o MVA | 0-75 | 0.0075 |  |  |  | 81-85 | 0.0125 |  |  | Income Select 5 | 0-75 | 0.0065 |  |  |  |  |  |  |  | Seure Income 125 | 0-75 | 0.0415 |  |  | Immediate Income With Life | 0-89
 |  |  | Endurance Plus | 0-75 | 0.0405 |  |  |  | 76-80 | 0 |  |  | Platinum Provider | 18-80 | 0.015 |  |  |  | 76-80 | 0.002 |  |  |  |  |  |  |  |  | 76-85 | 0.025 |  |  | Accumulator Plus 10 | 0-79
 |  |  |  | 76-80 | 0.0288 |  |  | Guarantee 7 w/o MVA | 0-75 | 0.0075 |  |  | Platinum Assure 5 | 0-75 | 0.0275 |  |  |  | 81-83 | 0.002 |  |  |  |  |  |  |  | Secure Income 125 OR | 0-75 | 0.0352 |  |  |  | 80-90
 |  |  | Endurance Elite | 0-75 | 0.026 |  |  |  | 76-80 | 0 |  |  |  | 76-85 | 0.015 |  |  | Income Select 7 | 0-75 | 0.012 |  |  |  |  |  |  |  |  | 76-85 | 0.0193 |  |  | Accumulator Plus 10 WA | 0-79
 |  |  |  | 76-80 | 0.0165 |  |  | SPIA-1 | 0-90 | 0.0168 |  |  |  | 86-90 | 0.005 |  |  |  | 76-80 | 0.0065 |  |  |  |  |  |  |  | Income 125 | 0-75 | 0.0415 |  |  |  | 80-90
 |  |  | Pro V1 | 0-75 | 0.0135 |  |  | Premiere Eagle 10 | 0-71 | 0.0289 |  |  | Platinum Secure | 0-75 | 0.035 |  |  |  | 81 | 0.0065 |  |  |  |  |  |  |  |  | 76-85 | 0.025 |  |  | Accumulator Plus 14 | 0-80
 |  |  |  | 76-80 | 0.0065 |  |  |  | 72 | 0.0289 |  |  |  | 76-85 | 0.02 |  |  | Income Select 10 | 0-75 | 0.038 |  |  |  |  |  |  |  | Income 125 OR | 0-75 | 0.0352 |  |  | Accumulator Plus 14 WA | 0-80
 |  |  |  | 81+ | 0.0032 |  |  |  | 73 | 0.0289 |  |  |  | 86-90 | 0 |  |  |  | 76-78 | 0.026 |  |  |  |  |  |  |  |  | 76-85 | 0.0193 |  |  | Index Accelerator 7 | 0-79
 |  |  |  |  |  |  |  |  | 74 | 0.0289 |  |  |  |  |  |  |  | Income Select Plus | 0-75 | 0.038 |  |  |  |  |  |  |  |  |  |  |  |  |  | 80-85
 |  |  |  |  |  |  |  |  | 75 | 0.0289 |  |  |  |  |  |  |  |  | 76-78 | 0.026 |  |  |  |  |  |  |  |  |  |  |  |  | Index Choice 9 (EIAT9C)
 |  |  |  |  |  |  |  |  | 76 | 0.0185 |  |  |  |  |  |  |  | Income Select Plus WA | 0-75 | 0.028
 |  |  |  |  |  |  |  |  | 77 | 0.0185 |  |  |  |  |  |  |  |  | 76-78 | 0.014 |  |  |  |  |  |  |  |  |  |  |  |  | Index Choice 9 (EIAT9C) WA
 |  |  |  |  |  |  |  |  | 78 | 0.0185 |  |  |  |  |  |  |  | Spirit Bonus | 0-75 | 0.031
 |  |  |  |  |  |  |  |  | 79 | 0.0185 |  |  |  |  |  |  |  |  | 76-78 | 0.0195 |  |  |  |  |  |  |  |  |  |  |  |  | Index Choice 9 (EIAT9P)
 |  |  |  |  |  |  |  |  | 80 | 0.0185 |  |  |  |  |  |  |  | Spirit Plus | 0-75 | 0.038
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-78 | 0.026 |  |  |  |  |  |  |  |  |  |  |  |  | Index Choice 9 (EIAT9P) WA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spirit Plus WA | 0-75 | 0.028
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-78 | 0.014 |  |  |  |  |  |  |  |  |  |  |  |  | Prosperity Elite 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spirit 7 | 0-75 | 0.012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-80 | 0.0065 |  |  |  |  |  |  |  |  |  |  |  |  | Prosperity Elite 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81 | 0.0065
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spirit 5 | 0-75 | 0.0065
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-80 | 0.0065
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81-83 | 0.002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spirit 3 | 0-75 | 0.002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-80 | 0.002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81-85 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lifetime Solutions | 0-75 | 0.028
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-78 | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lifetime Solutions S | 0-75 | 0.028
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76-78 | 0.014