Lookup Multiple Data With Any Criteria

[Edy_Franoto]

Good morning
I have the key data for store sales gifts as follows
While I have data entry

How do I in the data entry table with the “Reward” column I look for results based on the key table with the criteria “Date Start Program”,“Date End Program” (vs. Date in Data Entry),“Location”,“Channel”,"Product ID “Min Volume Transaction”,
"Min Volume Transaction" is the threshold of the sales quantity from the “QTY Sales” data entry which can be smaller or larger than the threshold

2021-08-20T17:00:00Z