Help needed modifying a formula to include date ranges.

[Mldeuser]

Hello

I need help with a formula.

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH($A7,Sheet2!A:A),Sheet2!O:O),0)

I need the above formula to not only find the match based on the above formula, I need it to also look at column K (a date column) and if the date in column K falls between a date range then bring back the amount in finds in column O.​

Thank you