How to compare one row of data to every row of data from another table in google sheet?

Hi everyone,

I need some helps on this task. My goal is to determine whether the Status in Column I is accepted or not. If it is accepted, then print Accept in Column I and print the Actual Time Accept in Column J based on Actual Time in Column C , otherwise just leave it blank.

Rules to determine the Status(Accept):

• The Time in Column H is greater than the Forecast Time in Column B.
• The Price in Column G is greater than the Actual Price in Column D.

Once these 2 rules are fulfilled, then print Accept in Column I and print the Actual Time Accept in Column J based on Actual Time in Column C , otherwise just leave it blank.

As you can see from my formula in cell I3, it only compare row by row (one row in Output compare to one row in input). What I want is comparing one row of data in Output to all the rows in Input to determine whether the Status is accepted or not.

Please give me some advice on this problem, I'm not sure this can be done without using Google Apps Script. Please let me know if you are not clear on what I'm asking about, any help will be greatly appreciated! Thank you.