Vlookup dates that are higher than a given one

[JFokker]

Dear all,

I have a brain breaker at the moment what I really consider as hard to solve... But luckily we have these wonderful minds available here that hopefully can help me further.

I have a table containing the following three colums;



COLUMN J - Order
COLUMN K - Reception date
COLUMN L - Shipment date

And in cells B3 the Order number and C3 a date field.

With the following formula I try to get date values out of column L;
=INDEX(L6:L10;MATCH(B3;$J$6:$J$10;"<"&C3))

In case of a double order I want to provide a date in cell C3 and it should then return the Shipment date that is higher than the value provided in C3. So basically a vlookup in several layers... I've attached an example file.

Is this possible?

Let me know if more info is required.

Thanks a lot for your help all!!