+ Reply to Thread
Results 1 to 2 of 2

Return Value between two dates on another sheet

  1. #1
    Registered User
    Join Date
    05-14-2015
    Location
    Kent
    MS-Off Ver
    365
    Posts
    20

    Cool 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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,837

    Re: Return Value between two dates on another sheet

    You have a circular ref err (formula in A3):
    =LOOKUP(2,1/('Period Dates'!C5:C17<=A3)/('Period Dates'!E5:E17>=A3),'Period Dates'!F5:F17)

    Should be:
    Please Login or Register  to view this content.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to return the 'earliest' and 'latest' dates from a list of dates is not working
    By Hawkmoth1 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-21-2017, 07:14 AM
  2. [SOLVED] Return the earliest and latest dates selected from a list of dates.
    By Hawkmoth1 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 02-01-2017, 09:41 AM
  3. Populating list of dates from another sheet with Start Dates and End Dates
    By Jesshloly in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2015, 04:07 AM
  4. VBA to filter by dates, return values only if between certain dates
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2015, 10:08 AM
  5. Calculation of dates, return blank when one of the dates is not populated
    By brian_2me in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2014, 10:59 AM
  6. [SOLVED] Formula to return dates into specific cell on another sheet
    By bdouglas1011 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2014, 11:39 AM
  7. Replies: 7
    Last Post: 01-16-2009, 05:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1