# Return Value between two dates on another sheet

#### mikey141

##### New Member
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)

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

##### MrExcel MVP
It should work...

What result are you getting? Is A3 = L5?

#### mikey141

##### New Member
Just returns 0 or in the workbook I'm trying to use the formula in it just displays the formula instead.

It should work...

What result are you getting? Is A3 = L5?

##### MrExcel MVP
Select the formula cells

Run Find&Select | Replace

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

Activate the Replace All button.

Replies
7
Views
148
Replies
3
Views
263
Replies
1
Views
211
Replies
4
Views
84
Replies
16
Views
721

1,141,204
Messages
5,704,944
Members
421,372
Latest member
Jamie11

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back