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
=LOOKUP(2,1/('Period Dates'!C5:C17<=A3)/('Period Dates'!E5:E17>=A3),'Period Dates'!F5:F17)

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
=LOOKUP(2,1/('Period Dates'!C5:C17<=A3)/('Period Dates'!E5:E17>=A3),'Period Dates'!F5:F17)
