I have two data validation cells:

- In one a user can select: All Fixed, Current Income, Balanced Appreciation, Balanced, Balanced Return, Balanced Appreciation, Appreciation, or All Equity.

- In the second, the user can select Accredited or Non-Accredited

Based off these two selections, I need cells to populate with allocation percentages (ie: if they choose Balanced Income and Non-Accredited, certain cells need to populate with 0% (representing cash), 20% (representing large cap), 4% (representing mid cap), 3% (representing small cap), 7% (for both int'l and emerging markets), etc.......

Each one of these would combinations would have a different % output.

Any ideas? I think I am way over my head.

Thanks for the help!