Hlookup issues

[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

[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

[royUK]

I suggest you read & follow the Forum Rules. If you can't be bothered then don't bother posting because we moderators aren't here to keep correcting your failure to do this.

[pike]

Hi sid_12
change the values from
35 - 40 to 35
40 - 45 to 40 etc...

=INDIRECT("'Sheet 2'!"&ADDRESS(MATCH(G6,'Sheet 2'!C$6:C$8,0)+5,MATCH($D6,'Sheet 2'!D$5:$L$5,1)+4))