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

[Steve]

help.appsheet.com

AND()

Are all true?

help.appsheet.com

OR()

Are any true?

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Edy_Franoto]

Hi Steve coile, how do you combine these three formulas

[Lynn]

Hi @Edy_Franoto
What have you tried?

[Edy_Franoto]

Hi Lynn,i have tried but i’m having trouble finding results when using keyword Criteria from “Min Volume Transaction” VS “Qty Sales”
Help me to get out of this problem

[Steve]

Please demonstrate that you’ve tried to solve your own problem by giving us examples of what didn’t work. Please also demonstrate that you tried the functions I suggested above.