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