Hi
Iam trying to find the rate for age group (approx Match) & value (exact match) from the following table with the following formula.
age=55
amount=200000
INDEX($C$21:$R$31,MATCH(55,$B$20:$B$31,TRUE),MATCH(200000,$C$20:$R$20,FALSE))
the value returned in 8800 instead of 8000.
Can anyone please help
<colgroup><col><col><col><col span="2"><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>
Iam trying to find the rate for age group (approx Match) & value (exact match) from the following table with the following formula.
age=55
amount=200000
INDEX($C$21:$R$31,MATCH(55,$B$20:$B$31,TRUE),MATCH(200000,$C$20:$R$20,FALSE))
the value returned in 8800 instead of 8000.
Can anyone please help
AGE | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000 | 300000 | 350000 | 400000 | 450000 | 500000 | 600000 | 700000 | 800000 |
5 | 1650 | 2000 | 2300 | 2700 | 3000 | 3400 | 3600 | 4000 | 4200 | 4700 | 5200 | 5700 | 6200 | 7000 | 7800 | 8500 |
25 | 1500 | 1900 | 2300 | 2600 | 2900 | 3200 | 3400 | 3700 | 4000 | 4500 | 4900 | 5500 | 6000 | 7000 | 7500 | 8000 |
30 | 1600 | 2000 | 2350 | 2650 | 3000 | 3300 | 3500 | 3800 | 4100 | 4600 | 5000 | 5600 | 6200 | 7200 | 8000 | 8800 |
35 | 1650 | 2050 | 2400 | 2700 | 3050 | 3350 | 3600 | 4000 | 4300 | 4900 | 5300 | 5900 | 6400 | 7500 | 8500 | 9000 |
40 | 1950 | 2350 | 2750 | 3100 | 3400 | 3800 | 4100 | 4450 | 4800 | 5400 | 6000 | 6500 | 7000 | 7700 | 8700 | 9300 |
45 | 2600 | 3100 | 3500 | 4000 | 4400 | 4700 | 5200 | 5700 | 6200 | 7000 | 7700 | 8500 | 9200 | 10500 | 11500 | 12500 |
50 | 3700 | 4500 | 5200 | 6100 | 6800 | 7500 | 8200 | 8900 | 9700 | 11000 | 12200 | 13800 | 15000 | 17000 | 20000 | 22000 |
55 | 4300 | 5200 | 6000 | 7000 | 8000 | 9000 | 9800 | 10400 | 11500 | 12500 | 14500 | 16000 | 17500 | 20000 | 23000 | 25000 |
60 | 4800 | 5800 | 6900 | 8000 | 8800 | 10000 | 10500 | 11600 | 13000 | 14800 | 16500 | 18000 | 20000 | 23000 | 26000 | 30000 |
65 | 5400 | 6500 | 7700 | 9000 | 10200 | 11600 | 12600 | 13700 | 14700 | 16700 | 19000 | 21000 | 23000 | 25000 | 30000 | 33000 |
70 | 6200 | 7200 | 8500 | 10000 | 11400 | 12800 | 14000 | 15000 | 16500 | 18800 | 21000 | 23500 | 26000 | 30000 | 35000 | 40000 |
<colgroup><col><col><col><col span="2"><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>