vlookup or IF formula on base of Age Bracket

[Nitin Shardul]

On Base of Age, No of Days, Travel Plan, Including or Excluding Premium Amount to be calculated

In Data Sheet Age is .69-40,41-70,71-75,76-80.

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[bosco_yip]

Another option,

In D6 :

=IF(B6="","",DATEDIF(B6,TODAY(),"y"))

In B11 :

=INDEX(Data!C7:AF19,MATCH(B8,Data!B7:B19,0),MATCH(1,INDEX((Data!C3:AF3=B10)*(Data!C4:AF4=B7),0),0)+MATCH(D6,{0.6,41,61})-1)

Regards
Bosco

 

[Nitin Shardul]

T

Hi ,

See the attached file.

Narayan

Thank you so much
It works

 

[Nitin Shardul]

Another option,

In D6 :

=IF(B6="","",DATEDIF(B6,TODAY(),"y"))

In B11 :

=INDEX(Data!C7:AF19,MATCH(B8,Data!B7:B19,0),MATCH(1,INDEX((Data!C3:AF3=B10)*(Data!C4:AF4=B7),0),0)+MATCH(D6,{0.6,41,61})-1)

Regards
Bosco

Thank you It Works, But B18 doesn't reflect in formula