Return Value between two dates on another sheet

Evening, I've tested the lookup formula within the same sheet to enter a date and it returns a period date (For Work), but when i want to search from another sheet it doesn't work

Below is on the same sheet
=LOOKUP(2,1/(C5:C17<=L5)/(E5:E17>=L5),F5:F17)

Below is from another sheet that doesnt work [/B]
=LOOKUP(2,1/('Period Dates'!C5:C17<=A3)/('Period Dates'!E5:E17>=A3),'Period Dates'!F5:F17)

https://www.excelforum.com/attachmen...1&d=1516567777