Help with formula

[junior1505]

Dear Experts,
Have the following data on Insurance premium based on age and insured amount.
Wish to tabulate the insurance amount for a particular person based on age.
Please help.
Regards.

Age To	₹ 2,00,000.00​	₹ 2,50,000.00​	₹ 3,00,000.00​	₹ 3,50,000.00​	₹ 4,00,000.00​	₹ 4,50,000.00​	₹ 5,00,000.00​
40​	₹ 876.74​	₹ 1,033.68​	₹ 1,099.76​	₹ 1,251.98​	₹ 1,327.50​	₹ 1,470.28​	₹ 1,517.48​
60​	₹ 1,168.20​	₹ 1,378.24​	₹ 1,466.74​	₹ 1,668.52​	₹ 1,770.00​	₹ 1,959.98​	₹ 2,022.52​
100​	₹ 1,752.30​	₹ 2,067.36​	₹ 2,199.52​	₹ 2,503.96​	₹ 2,655.00​	₹ 2,939.38​	₹ 3,034.96​
Employee ID	Employee Name	Age	Sum Insured	Premium
50001​	Ramesh K	58​	₹ 2,00,000.00​	₹ 1,168.20​
50002​	Kareena B	40​	₹ 2,50,000.00​	??
50003​	Sanjay S	32​	₹ 4,00,000.00​	??
50004​	Sam C	41​	₹ 3,50,000.00​
50005​	Arpita D	65​	₹ 5,00,000.00​

 

[mamady]

Hi Dear,

Please try the following

Book1
	A	B	C	D	E	F	G	H	I	J
2	Age From	Age To	2,00,000.00	2,50,000.00	3,00,000.00	3,50,000.00	4,00,000.00	4,50,000.00	5,00,000.00
3	0	40	876.74	1,033.68	1,099.76	1,251.98	1,327.50	1,470.28	1,517.48
4	41	60	1,168.20	1,378.24	1,466.74	1,668.52	1,770.00	1,959.98	2,022.52
5	61	100	1,752.30	2,067.36	2,199.52	2,503.96	2,655.00	2,939.38	3,034.96
6
7
8	Employee ID	Employee Name	Age	Sum Insured	Premium
9	50001	Ramesh K	58.00	2,00,000.00	1,168.20
10	50002	Kareena B	40.00	2,50,000.00	1,033.68
11	50003	Sanjay S	32.00	4,00,000.00	1,327.50
12	50004	Sam C	41.00	3,50,000.00	1,668.52
13	50005	Arpita D	65.00	5,00,000.00	3,034.96
Sheet1

Cell Formulas
Range	Formula
E9:E13	E9	=INDEX($B$2:$I$5,MATCH(VLOOKUP(C9,$A$2:$B$5,2,1),$B$2:$B$5),MATCH(D9,$B$2:$I$2))

Best Regards

 

[RoryA]

@junior1505
Please take a minute to read the forum rules on cross-posting, and then add the relevant links here to your posts in other forums. Thank you.

 

[junior1505]

Greetings of the day,
Appreciate you, @RoryA for bringing it to my notice. To be honest, had not read the rules about cross posting, but went thru them now.
My Sincere apologies to the forum and you all.
Would never attempt again.
Regards.

 

[junior1505]

Greetings of the day, @mamady ,
Appreciate the feedback, help and guidance with regards to the formula.
Well, it took a little bit of time for me to understand, but eventually could apply it.
Thanks for the help.
Regards.