I would set your table up slightly differently so that you have only
the start age in column A, like this:

A B C D
Age Employee EE Age Rate
0 $0.05 33 0.08
25 $0.06
30 $0.08
35 $0.09
40 $0.10
45 $0.15
50 $0.23
55 $0.44
60 $0.68
65 $1.27
70 $2.06

Then in D2 you can have this formula:

=VLOOKUP(C2,A$2:B$12,2)

Hope this helps.

Pete


On Oct 29, 8:40*pm, GL wrote:
Here is what I'm trying to accomplish...I want a formula that will populate
the rate based on the employee's age...
So I want it to compare column C to the range in column A and return the
rate from column B to Column D.

As far as I can tell, there are too many options to use nested IF
statements. *Can anyone help?

A * * * * * * * B * * * * * * * C * * * * * * *D
Age * * Employee * * * *EE Age *Rate
0-24 * *$0.05 * 33 * * *0.08
25-29 * $0.06
30-34 * $0.08
35-39 * $0.09
40-44 * $0.10
45-49 * $0.15
50-54 * $0.23
55-59 * $0.44
60-64 * $0.68
65-69 * $1.27
70+ * * $2.06