Hlookup issues

**sid_12** · 07-17-2010, 02:18 AM

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** · 07-17-2010, 03:52 AM

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** · 07-17-2010, 06:01 AM

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** · 07-17-2010, 07:26 AM

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))