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

Life
 |  | Allianz | Plan | Age | Comm |  | Americo | Plan | Age | Comm |  | Aviva | Plan | Age | Comm |  | Foresters | Plan | Age | Comm |  | Forethought | Plan | Age | Comm |  | Genworth | Plan | Age | Comm |  | Lincoln Financial | Plan | Age | Comm |  | Mutual Of Omaha | Plan | Age | Comm |  | North American | Plan | Age | Comm |  | One America | Plan | Age | Comm |  | Protective Life | Plan | Age | Comm |  | Royal Neighbors | Plan | Age | Comm |  | TransAmerica | Plan | Age | Comm |  | United of Omaha | Plan | Age | Comm
Americo |  |  | 10 yr Term | 18-65 | 0.369 |  |  | Life Crest Indexed |  | 0.65 |  |  | Advantage Builder II |  | 0.65 |  |  | Life First 10 yr Med |  | 0.35 |  |  | Freedom | 50-75 | 0.75 |  |  | Colony 10 yr Term UL |  | 0.6 |  |  | Life Current UL |  | 0.6 |  |  | WL Express | 0-75 | 0.7 |  |  | NAC Legacy SPWL | 0-80 | 0.058 |  |  |  |  |  |  |  | Survivorship Term 10 |  | 0.47 |  |  | SPWL |  |  |  |  | 250K Jet Issue 15 yr Term |  | 0.7 |  |  | Legacy SPWL | 0-75 | 0.045
Continental Life |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Life First 20 yr Med |  | 0.6 |  |  |  | 76-80 | 0.6 |  |  | Colony 15 yr Term UL |  | 0.68 |  |  | LifeReserve UL (2009) |  | 0.6 |  |  |  | 76+ | 0.6 |  |  |  | 81-85 | 0.028 |  | Assetcare IV | SL 10-12 Pay |  | 0.25 |  |  | Survivorship Term 20 |  | 0.57 |  |  | $10000.00-$19999.00 |  | 0.05 |  |  | 250K Jet Issue 20 yr Term |  | 0.74 |  |  |  | 76+ | 0.0257
Foresters |  |  | 20 yr Term | 18-65 | 0.495 |  |  | Life Crest |  | 0.65 |  |  | Advantage Builder II W/ SI or GI |  |  |  |  | Life First 30 yr Med |  | 0.6 |  |  |  |  |  |  |  | Colony 20 yr Term UL |  | 0.75 |  |  | LifeReserve Uindexed UL (2011) |  | 0.6 |  |  | Term Life |  | 0.81 |  |  | Addvantage 10 yr Term |  | 0.55 |  |  | SL 13-17 Pay |  | 0.33 |  |  | Survivorship Term 30 |  | 0.67 |  |  | $20000-99999.00 |  | 0.07 |  |  | 250K Jet Issue 30 yr Term |  | 0.74 |  |  | Mortgage Term |  | 0.6
Genworth |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Life First 20 yr w/o Med & FRR |  | 0.75 |  |  |  |  |  |  |  | Colony 30 yr Term UL |  | 0.75 |  |  | LifeGuarantee Plus UL (2009) |  | 0.6 |  |  | Mortgage Term Life |  | 0.81 |  |  | Addvantage 15yr Term |  | 0.58 |  |  | SL 18-20 Pay |  | 0.425 |  |  | Modified Life |  | 0.59 |  |  | $100000.00+ |  | 0.05 |  |  | AcciProtector |  | 0.72 |  |  | Survivor GUL |  | 0.45
Lafayette Life |  |  | 30 yr Term | 18-50 | 0.495 |  |  | Lifetime Legacy SPWL | 55-70 | 0.08 |  |  | Lifetime Builder |  | 0.65 |  |  | Life First 30 yr w/o Med & FRR |  | 0.75 |  |  |  |  |  |  |  | [NAME] |  | 0.62 |  |  | LifeGuarantee UL (2011) |  | 0.6 |  |  | Term Life Express |  | 0.81 |  |  | Addvantage 20 yr Term |  | 0.62 |  |  | SLWL |  | 0.525 |  |  | OneStep Life |  | 0.59 |  |  | UL | 0-54 | 0.7 |  |  | Accumulation UL |  | 0.72 |  |  | [NAME] |  | 0.54
Lincoln Financial |  |  |  |  |  |  |  |  | 71-75 | 0.06 |  |  |  |  |  |  |  | Life First 20 yr w/o Med W/FRR |  | 0.7 |  |  |  |  |  |  |  | [NAME] |  | 0.62 |  |  | LifeGuaranteeSUL (2011) |  | 0.6 |  |  |  |  |  |  |  | Builder IUL |  | 0.72 |  |  | JL 10-12 Pay |  | 0.25 |  |  | Centenial G II |  | 0.59 |  |  |  | 55-85 | 0.7 |  |  | TransAce UL |  | 0.62 |  |  | Term Life Express |  | 0.81
Madison National |  |  | Legacy Planner SPWL | 50-69 | 0.072 |  |  |  | 76-80 | 0.04 |  |  | Lifetime Builder W/ ECVR |  | 0.07 |  |  | Life First 30 yr w/o Med W/FRR |  | 0.7 |  |  |  |  |  |  |  | Lifetime Protector SG II |  | 0.62 |  |  | DurationGuarantee UL |  | 0.6 |  |  |  |  |  |  |  | Custom Accumulator III |  | 0.72 |  |  | JL 13-17 Pay |  | 0.25 |  |  | Centenial G II Plus |  | 0.59 |  |  | WLLP | 0-85 | 0.7 |  |  | Champion Term 10 |  | 0.66 |  |  | Term Life Complete
Monumental Life |  |  |  | 70-79 | 0.045 |  |  |  | 81-85 | 0.03 |  |  |  |  |  |  |  | Big UL |  | 0.65 |  |  |  |  |  |  |  | [NAME] |  | 0.68 |  |  | MoneyGuard SP |  | 0.036 |  |  |  |  |  |  |  | Custom Growth CV |  | 0.72 |  |  | JL 18-20 Pay |  | 0.25 |  |  | Centenial Survivor G |  | 0.59 |  |  | WL 20 Pay | 0-80 | 0.7 |  |  | Champion Term 15 |  | 0.68 |  |  | $1-$499999.00 |  | 0.81
North American |  |  |  | 80-85 | 0.03 |  |  |  | 81-85 TOB | 0.01 |  |  | Lifetime Builder W/ SI or GI |  | 0.12 |  |  | Smart UL |  | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0.18 |  |  |  |  |  |  |  | Custom Guarantee |  | 0.7 |  |  | JLWL |  | 0.25 |  |  | ProClassic |  | 0.59 |  |  | WL PDU@65 | 0-60 | 0.7 |  |  | Champion Term 20 |  | 0.7 |  |  | $500000.00+ |  | 0.68
Protective Life |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared AD & D Term |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  | LifeElements 1yr Term |  | 0 |  |  |  |  |  |  |  | CustomTerm GUL |  | 0.72 |  |  |  |  |  |  |  | ProCLassic W/ECVR |  | 0.25 |  |  | 30 yr Lvl Term | 16-50 | 0.7 |  |  | Champion Term 30 |  | 0.7 |  |  | Term Life Answers 20 yr |  | 0.45
Royal Neighbors |  |  | Generation Planner II | 0-80 | 0.51 |  |  | [NAME] |  | 0.65 |  |  | Indexed Survivor UL |  | 0.65 |  |  | WL 100 Pay EZ Issue |  | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  | LifeElements 10yr Lvl Term |  | 0.65 |  |  |  |  |  |  |  | Survivorship GIUL |  | 0.66 |  |  |  |  |  |  |  | Secure T-10 |  | 0.42 |  |  | 30 yr Lvl Term RPR | 16-50 | 0.7 |  |  | Perfered Global IUL |  | 0.7 |  |  | Term Life Answers 30 yr |  | 0.45
TransAmerica |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WL 100 Pay Fully UW |  | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  | LifeElements 15yr Lvl Term |  | 0.73 |  |  |  |  |  |  |  | Rapid Builder IUL |  | 0.72 |  |  |  |  |  |  |  | Secure T-15 |  | 0.52 |  |  | 20 yr Lvl Term | 16-60 | 0.7 |  |  | Prefered Global IUL 500+ |  | 0.62 |  |  | Term Life Answers 15 yr |  | 0.38
 |  |  | GenDex Foundation | 0-80 | 0.51 |  |  | Home Mortgage 100 term |  | 0.65 |  |  | Guarantee UL Solution |  | 0.65 |  |  | WL 20 Pay UW |  | 0.38 |  |  |  |  |  |  |  |  |  |  |  |  | LifeELements 20yr Lvl Term |  | 0.8 |  |  |  |  |  |  |  | Guarantee Builder IUL |  | 0.72 |  |  |  |  |  |  |  | Secure T-20 |  | 0.57 |  |  | 20 yr Lvl Term RPR | 16-60 | 0.7 |  |  | Home Protetor Elite 15 |  | 0.7 |  |  | Term Life Answers 10 yr |  | 0.35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Life Elements 30yr Lvl Term |  | 0.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secure T-25 |  | 0.57 |  |  | 10 yr Lvl Term | 16-70 | 0.6 |  |  | Home Protector Elite 20 |  | 0.74 |  |  | Accum UL Plus
 |  |  | GenDexMomentum | 0-80 | 0.585 |  |  | Home Mortgage 125 Term |  | 0.75 |  |  | Term 2009 10 Yr |  | 0.56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secure T-30 |  | 0.57 |  |  | 10 yr Lvl Term RPR | 16-70 | 0.05 |  |  | Home Protector Elite 30 |  | 0.74 |  |  | $1-499999.00 |  | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Youth WL LP | 0-17 | 0.7 |  |  | Provider FE |  | 0.68 |  |  | $500000.00+ |  | 0.38
 |  |  | GenDex Survivor | 18-80 | 0.563 |  |  | Home Mortgage 100 UL |  | 0.65 |  |  | Term 2009 20 Yr |  | 0.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Youth WL 20 Pay | 0-17 | 0.7 |  |  | Provider Plus FE |  | 0.53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seurity Plus FE |  | 0.68
 |  |  |  |  |  |  |  | Home Mortgage 125 UL |  | 0.75 |  |  | Term 2009 30 Yr |  | 0.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TransTerm 10 |  | 0.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TransTerm 15 |  | 0.68
 |  |  |  |  |  |  |  | EZ Issue 100 Term |  | 0.65 |  |  | Term 2009 ART |  | 0.52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TransTerm 20 |  | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TransTerm 25 |  | 0.7
 |  |  |  |  |  |  |  | Ez Issue 100 UL |  | 0.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TransTerm 30 |  | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Freedom IUL II |  | 0.74
 |  |  |  |  |  |  |  | EZ Issue 125 Term |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fredom Global IUL II |  | 0.74
 |  |  |  |  |  |  |  | EZ Issue 125 UL |  | 0.75
 |  |  |  |  |  |  |  | Home Mortgage ADB Term |  | 0.65