I have a column for age. I have a chart with age banded rates ( <25, 25 to
29, etc.) Each age bracket has a rate associated with it. I am trying to do
a formula that would populate in a seperate column the rate associated with a
particular age.

ex:
m2 has age 34
the rate for 30-34 age bracket is $.08
There are more than 7 age brackets so the IF function will not work.
Age brackets are as follows:
<25 = $.05
25-29 = $.06
30-34 = $.08
35-39 = $.09
40-44 = $.10
45-49=$.15
50-54 = $.23
55-59 = $.43
60-64 = $.66
65-69 = $1.27
69 = $2.06

Any suggestions?
--
God bless.