Return Value between two dates on another sheet

mikey141

New Member
Joined
May 14, 2015
Messages
11
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)

:banghead:
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,165
Select the formula cells

Run Find&Select | Replace

Set Find What to: =
Set Replace With to: =

Activate the Replace All button.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,369
Messages
5,444,059
Members
405,264
Latest member
JohnP1972

This Week's Hot Topics

Top