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

[NAME] |  |  | Age | State | [NAME] | Comm |  |  | Age | State | [NAME] | Comm |  |  | Age | State | [NAME] | Comm |  |  | Age | State | [NAME] | Comm |  |  | Age | State | [NAME] | Comm |  | Age | State | [NAME] | Comm |  | Age | State | [NAME] | Comm
AARP |  | AARP |  |  |  |  |  | Assured | -65 | ID | Normal | 0 |  | Gerber | 65+ | ID | Normal | 0.135 |  | Loyal |  |  |  |  |  | MofO |  |  |  |  | Sentinel |  |  |  |  | UofO
Assured |  |  |  |  |  |  |  |  | 65+ | ID | Normal | 0.135 |  |  | 65+ |  | Guaranteed | 0.063
Gerber |  | B | All | ID | Normal | 170 |  | All | -65 | ID | Guaranteed | 0 |  | All |  |  |  |  |  | A | All | ID | Normal | 0.05 |  | All | 65-80 | ID | Normal | 0.12 | All | 65-79 | ID | Normal | 0.15 | All | 65-80 | ID | Normal | 0.12
Loyal |  | C |  |  | Normal | 170 |  |  | 65+ | ID | Guaranteed | 0.063 |  |  | 65+ | OR | Normal | 0.135 |  |  |  |  |  |  |  |  | 81+ |  | Normal | 0.06 |  | 80+ |  | Normal | 0.06 |  | 81+ |  | Normal | 0.06
MofO |  | C Select |  |  | Normal | 170 |  |  |  |  |  |  |  |  | 65+ |  | Guaranteed | 0.063 |  | B | 65-79 | ID | Normal | 0.11 |  |  | 65-80 |  | Guaranteed | 0.052 |  | 65-79 |  | Guaranteed | 0.06 |  | 65-80 |  | Guaranteed | 0.052
Sentinel |  | F |  |  | Normal | 170 |  | All |  | OR | Normal | 0.135 |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.06 |  |  | 81+ |  | Guaranteed | 0.018 |  | 80+ |  | Guaranteed | 0.0165 |  | 81+ |  | Guaranteed | 0.018
UofO |  | F Select |  |  | Normal | 170 |  |  |  | OR | Guaranteed | 0.063 |  |  | 65+ | WA | Normal | 0.045
 |  | N |  |  | Normal | 170 |  |  |  |  |  |  |  |  | 65+ |  | Guaranteed | 0.045 |  | D | 65-79 | ID | Normal | 0.11 |  |  | 65-80 | OR | Normal |  |  | 65+ | OR | Normal | 0.145 |  | 65-80 | OR | Normal | 0.1
AARP |  |  |  |  |  |  |  |  |  | WA | Normal | 0.045 |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.06 |  |  | 81+ |  | Normal |  |  | 65+ |  | Guaranteed | 0.06 |  | 81+ |  | Normal | 0.1
 |  | B | All | WA | Normal | 0.067 |  |  |  | WA | Guaranteed | 0.045 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65-80 |  | Guaranteed |  |  |  |  |  |  |  | 65-80 |  | Guaranteed | 0.1
B |  | C |  |  | Normal | 0.067 |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 65-79 | ID | Normal | 0.13 |  |  | 81+ |  | Guaranteed |  |  | 65+ | WA | Normal | 0.045 |  | 81+ |  | Guaranteed | 0.1
C |  | C Select |  |  | Normal | 0.067 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.08 |  |  |  |  |  |  |  | 65+ |  | Guaranteed | 0.045
C Select |  | F |  |  | Normal | 0.067 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65-80 | WA | Normal | 0.045 |  |  |  |  |  |  | 65-80 | WA | Normal | 0.0563
F |  | F Select |  |  | Normal | 0.067 |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 65-79 | ID | Normal | 0.13 |  |  | 81+ |  | Normal | 0.033 |  |  |  |  |  |  | 81+ |  | Normal | 0.0563
F Select |  | N |  |  | Normal | 0.067 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.08 |  |  | 65-80 |  | Guaranteed | 0.045 |  |  |  |  |  |  | 65-80 |  | Guaranteed | 0.0563
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81+ |  | Guaranteed | 0.033 |  |  |  |  |  |  | 81+ |  | Guaranteed | 0.0563
 |  | B | All | OR | Normal | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 65-79 | ID | Normal | 0.13
Assured |  | C |  |  | Normal | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.08
 |  | C Select |  |  | Normal | 125
All |  | F |  |  | Normal | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 65-79 | ID | Normal | 0.13
 |  | F Select |  |  | Normal | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.08
Gerber |  | N |  |  | Normal | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | All | OR | Normal | 0.05
All
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 65-79 | OR | Normal | 0.13
Loyal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.13
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 65-79 | OR | Normal | 0.13
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.13
D
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 65-79 | OR | Normal | 0.15
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.15
G
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 65-79 | OR | Normal | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.15
MofO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 65-79 | OR | Normal | 0.15
All |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.15
Sentinel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 65-79 | OR | Normal | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.15
All
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | All | WA | Normal | 0.05
UofO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 65-75 | WA | Normal | 0.13
All |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75+ |  | Normal | 0.07
MedStatus |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 65-75 | WA | Normal | 0.13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75+ |  | Normal | 0.07
Normal
Guaranteed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 65-79 | WA | Normal | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 65-79 | WA | Normal | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 65-79 | WA | Normal | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 65-79 | WA | Normal | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80+ |  | Normal | 0.09