lookup if matching item and between dates

Hello,

I've got 2 tables with different deliveries with a range of different items. Both tables looks something like this:

OrderId	ItemId	StartDate	StopDate
4531	11	11/12/10	12/01/10
4532	15	06/13/14	07/14/14
..	..	..	..

And I want to know if the an item in the table1 have started being delivered in table2 during the time it's been delivered in table1.

Would be very happy if you could give me some help on the issue!

Solved it using index match as Array.

(http://www.exceltactics.com/vlookup-...index-match/4/)