Find the first value in a column that is greater and and return cell next to it

[helpmeplea5e]

Hi!

As the title states, I am trying to find the first value in a column that is greater and return the cell next to it. In the attached document I am trying to have a formula in Sheet1 Column G that will look up on Sheet2 the date that is in Sheet1 Column D and then look at each day after and tell me which day the price (Sheet2 Column C) is higher than the value in Sheet1 Column E.

For example on Sheet1 Row 2: The formula would look at 8/14/2019 and then go to Sheet2 Column A to find that date. Then it would look at each day after and see when the price (Sheet 2 Column C) is greater than the price in Sheet1 Column E and then return the date. So in this example it would return 8/19/2019.

Please let me know if I can clarify anything.

Thanks!