Index Sequence Row formula using data from another cell as part of the formula

Hi, I have a worksheet with an import of sales transactions. I'm using this formula to find all transactions within the last year.   =MAX(IF('Product Import'!$E:$E>='Product Bought'!$G$2,ROW('Prod...