Results 1 to 7 of 7

Lokup Function help needed

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Nebraska, United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Lokup Function help needed

    Sample.xlsxHi all,

    Need some help on a excel issue with Lookup (possibly not using right function right now but that is what we started with).

    Workshet A, we have data in columns A - D and then a date in column E that is the due date, and then the columns that we want to determine are column F which we want the release date and column G the release number.

    Worksheet B, we have column A with the release date and then column B with the release number.

    We want the due date to be less than or equal to the release date. Examples:
    due date of 04/01/13 we would want the first row in worksheet B with release date of 04/15/13 (col. F) and release number #1 (Col. G)
    due date of 04/30/13 we would want the second row in worksheet B with release date of 05/15/13 (col. F) and release number #2 (Col. G)
    due date of 05/16/13 we would want the third row in worksheet B with release date of 06/15/13 (col. F) and release number #3 (Col. G)


    Right now we have this formula
    =IFERROR(LOOKUP(DATEVALUE(A4),DATEVALUE(Releases!$A$2:$A$100),Releases!$B$2:$B$100),"Before First Listed Date")

    but on a due date of 05/01/13 it is returning release date of 04/15/13 and release # of 1.

    Any help would be greatly appreciated!! Thank you!!
    Last edited by webba05; 04-15-2013 at 09:56 AM.

Thread Information

Users Browsing this Thread

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

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