calculate in large array

[Memar]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Projected price Inflation [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date [/TD]
[TD]Rate [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]5%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2020[/TD]
[TD]5.5%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2021[/TD]
[TD]6%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2022[/TD]
[TD]6.5%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Price amount by unit[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date [/TD]
[TD]Amount [/TD]
[TD]Desired result [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]1,000[/TD]
[TD]1000 x 5%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2020[/TD]
[TD]1,200[/TD]
[TD]1,200 x 5.5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2021[/TD]
[TD]1,500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/1/2022[/TD]
[TD]2,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to multiple the price amount by the projected estimated rate for each year. example if the date is greater than January 1, 2019 multiply 1,000 by 5% if the date is greater than January 2020 to multiply 1,200 by 5.5% etc. Which Excel function is the best to do this kind of calculation for large amount of data like this.

Thank you very much for your help and time.

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G
1	Date	Amount	Desired result	or		Year	Rate
2	01-01-19	1,000	50	1050		01-01-19	5%
3	01-01-20	1,200	66	1266		01-01-20	5.50%
4	01-01-21	1,500	90	1590		01-01-21	6%
5	01-01-22	2,000	130	2130		01-01-22	6.50%
6	05-05-22	1,000	65	1065
7	09-09-22	1,000	65	1065
3a

Cell Formulas
Range	Formula
C2	=LOOKUP(A2,$F$2:$G$5)*B2
D2	=(1+LOOKUP(A2,$F$2:$G$5))*B2