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!!

Attached Files

Example.xlsx (10.9 KB, 10 views)

This will return the first match for B3 where shipdate is later than the C3 date:

=INDEX(L6:L10,MATCH(1,INDEX((J6:J10=B3)*(L6:L10>C3 ),0),0))

This works, great!!!!

Thanks a lot