Multiple criteria (date range, product code, value) vlookup and if functions or do I need index and match?

[StaceyVECL]

I apologise if this has been asked before but I can't seem to find an answer.

I need the end result to be a discount given based on the product code, date range and quantity.

For example: Based on the order date, product code, and quantity from the below table the discount should be -15.00. Obviously if someone were to order 2 it would -30.00

A	B	C	D	E
ORDER DATE	PRODUCT CODE	CUSTOMER CODE	QUANTITY	DISCOUNT
13/04/2022	B200	123456	1	-15.00

I have separate tab with the discount values and dates called "Formulas"

A	B
PRODUCT CODE	DISCOUNT
	START DATE
	END DATE
B200	-15.00
	13/04/2022
	03/05/2022

I need column E on the first table to look up column A, B and the dates from the formulas tab and give me the discount result.

I've used IFS, SUMIFS, and vlookup's before but I just can't seem to figure this one out.

Thanks in advance.