calculate in large array

[Memar]

Projected price Inflation
Date	Rate
1/1/2019	5%
1/1/2020	5.5%
1/1/2021	6%
1/1/2022	6.5%
Price amount by unit
Date	Amount	Desired result
1/1/2019	1,000	1000 x 5%
1/1/2020	1,200	1,200 x 5.5
1/1/2021	1,500
1/1/2022	2,000

<tbody>
</tbody>

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