get cells to populate based off two data validation entries:

Add a sheet to your workbook called TABLE.

In the table put your income types down column A starting at A2. These would be:

Accredited-All Fixed
Accredited-Current Income
Accredited-Balanced Appreciation
Accredited-Balanced
Accredited-Balanced Return
Accredited-Balanced Appreciation
Accredited-Appreciation
Accredited-All Equity
Non-Accredited-All Fixed
Non-Accredited-Current Income
Non-Accredited-Balanced Appreciation
Non-Accredited-Balanced
Non-Accredited-Balanced Return
Non-Accredited-Balanced Appreciation
Non-Accredited-Appreciation
Non-Accredited-All Equity

Put in B1 - CASH
Put in C1 - LARGE CAP
Put in D1 - MID CAP
Etc....

Now fill in the table with the percentages.

This creates a lookup table.

Back on another sheet you would lookup percentages using an INDEX/MATCH.

For Accredited (in cell A1) and All Fixed in cell (A2) and MID CAP (in cell A3) the formula would read:

=INDEX(Table!$B$2:$Z$100, MATCH($A1 & "-" & $A2, Table!$A$2:$A100, 0), MATCH($A3, Table!$B$1:$Z$1, 0))

Format B6 as percentage, then enter this formula and copy downward:

=INDEX($E$5:$Q$20, MATCH($B$3&"-"&$B$4, INDEX($C$5:$C$20&"-"&$D$5:$D$20, 0), 0), MATCH($A6, $E$4:$Q$4, 0))

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.