Excel Array with condition

[Memar]

I just want to look up the dates in A column with in the array in F column.If the date in column A is less than from the first starting date in column F, there is no a desired result. But if the date in A3 is between the date in F2 and F3, multiply the amount in column B3 by G2. If the date in A4 is greater or equal to F3 and F4, multiply the amount in B4 by G3 etc. What would be the best Excel Function to calculate this type of large date in Excel.

	A	B	C	D	E	F	G
1	Date	Amount	Desired result			starting Date	increase Rate
2	12/31/2018	1,000	0			06/30/2019	5%
3	07/30/2019	1,200	60			12/31/2019	7.5%
4	12/31/2019	1,260	94.50			06/01/2020	9%
5	06/15/2020	1354.50	121.50			12/31/2020	12%
6	12/31/2020	1476.40	177.16
7

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Thank you for your help and time

 

[bosco_yip]

Try,

1] Assume your "Result Table" in A1:C6, and "Lookup Table" in F1:G5

2] In "Desired result" C2, copied down :

=IFERROR(LOOKUP(9^9,G$2:G$5/(F$2:F$5<=A2))*B2,0)

Regards
Bosco