Formula - highest value

[Dtromdtrom]

Good Morning

I am new to this forum and wish to have some help with an issue! Please see sample spreadsheet as attached. I had issues uploading the actual spreadsheet. Cell G1 is a value to be entered manually. When the value in column B is greater than the value in cell G1 for the first time, I want the corresponding value in column C to be returned in cell G2. In this example, I have entered the value '100' in cell G1. The first time the value in column B goes above 100 is on 23/02/2020 and therefore the corresponding value to be returned is 16.

Dates are always in order (oldest first) and the data could go to row 5000. Values in row B are not always in order. The attached image is just a sample.

Can anyone help with the formula that needs to be entered in cell G2? I have researched the forum with no luck. I am using Excel 365.

Many thanks

[Pepe Le Mokko]

There are instructions at the top of the page on how to post a sample sheet.Thanks

[Dtromdtrom]

Thank you. I have now managed to upload the file correctly.

[Phuocam]

Try this:

=INDEX($C$2:$C$27,MATCH(TRUE,$B$2:$B$27>G1,0))