I need a lookup formula to find the price of a commodity that occurs within a date range.

(preferrably a non-array{} formula please)

Here is my example (see attached image)

Column A contains the date & time stamp, & column B is the price of commodity' Y' at that time.

Cell D1 contains my customer's target price order for commodity 'Y'.

Cell D2 contains the time the target order was placed.

I want a vookup formula that will tell me if the customers target order (D1) was achieved

any time after he placed the order (D2) until the current time (i.e. =now()).

Note: the data in Column A will be sorted in accending order, & I just want to find the first instance of a positive result.

So in this example, the target was achieved at 4/20/14 7:00:00 pm (ROW 10) when the commodity price in column B exceeded his target price of $149.50. The formula will return a result of $150.00 (cell B10). Note, in this example the formula will ignore the $150.00 vaule in ROW2 becasue it occurred before he placed the target order.

thanks.

table.jpg
=INDEX($A$2:$A$12,MATCH(1,

Value, column B

=INDEX($B$2:$B$12,MATCH(1,