Insert value based on range
Split your age range into 2 cells:
0-24
Should be:
0.....24
Where 0 is in one cell and 24 is another cell.
With your last boundary ,70+, enter it simply as 70.
Then you do a lookup on the *lower boundary* age range of cells.
Assume:
A1:11 = lower age boundary
B1:B11 = upper age boundary
C1:C11 = numeric values
D1 = 33
=VLOOKUP(D1,A1:C11,3)
--
Biff
Microsoft Excel MVP
"GL" wrote in message
...
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
|