Excel 2007 : Trace amounts from 2nd sheet with below cateria

[sid_12]

Hi,

I would like to track the amount from sheet 2 to sheet 1 with matching 3 creteria (age, sum insured and amount)

Ex:- if the age is 31 with suminsured 200000 than the amount should be Rs.2530
(as per the table in sheet2)

Please help me to resolve this.

Thanks
Shaddy

[rethguals]

1. D5:L5 in sheet2 -> 0.25, 5, 35, 40, 45, 50, 55, 60, 65
2. H6 in sheet1 : =INDEX(Sheet 2!$D$6:$L$8,MATCH(G6,Sheet 2!$C$6:$C$8,0),MATCH(D6,Sheet 2!$D$5:$L$5,1))
3. Copy & paste formula from H7 to H10