I have the following entry fields:
A B C D
1 inv. obj % cash % Bond % stock
2 Growth 10% 30% 60%
3
4
Then I have made a table that contains criteria as follows:
A b c d
5 Inv. obj cash low range cash high range bond low
6 Growth 0% 3% 6%
7 Income 5% 12% 60%
8 Preservation 20% 60% 30%

Etc. And column e would be the bond high range, then
column f would be the stock low range, and column g would
be the stock high range.

I would like to create a formula in cell E2 that says the
following:
Lookup my entry in a2 in the table from column a6:a8.
Then determine if my cash percentage entry is either
within the range, or out of the range that is determined
by the table column b and c(for whichever inv. obj. that
is being looked up. If it is out of range, return "out of
range", if it is in range, return "OK".

Thanks alot.
Scott