+ Reply to Thread
Results 1 to 6 of 6

Vlookup Returning Values based on Date Range

  1. #1
    Registered User
    Join Date
    01-29-2008
    Posts
    68

    Vlookup Returning Values based on Date Range

    I have a spreadsheet where I need to return a value of 1 if the number on one spreadsheet matches a number on another spreadsheet and the date next to it falls into the range I've specified at the top of the first sheet if not it will return a 0.I've attached a file that simplifies it into one sheet. I need to return a 1 in column D if the matching number from column E has a date next to it within the range specified at the top. I was using a vlookup which works fine, but I would like to be able to change the data (1,0) based on the date range. The formula I'm using is VLOOKUP(D4,$E$4:$F$15,2,FALSE). Any help would be appreciated
    Attached Files Attached Files
    Last edited by NBVC; 01-10-2011 at 04:55 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Vlookup Returning Values based on Date Range

    Are we matching C and E or E and F?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Vlookup Returning Values based on Date Range

    Try:

    =--(AND(VLOOKUP(C4,$E$4:$G$15,3,0)>=$B$1,VLOOKUP(C4,$E$4:$G$15,3,0)<=$B$2))
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Registered User
    Join Date
    01-29-2008
    Posts
    68

    Re: Vlookup Returning Values based on Date Range

    That did the trick. Thank you very much.

  5. #5
    Registered User
    Join Date
    12-22-2008
    Location
    india
    Posts
    7

    Re: Vlookup Returning Values based on Date Range

    Hi,
    Thought to revive the this thread since my problem is similar.
    Attaching the sheet as I want to return the data. Please refer to the attachment as it has all required details.
    "Needs the value appearing in column G, if the value in A5 is (less than F5, then return G5), if its equal or more than F5 but less than F6, then return G6), if its equal or more than F6 but less than F7, then return G7 ) and so on……."
    Attached Files Attached Files

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Vlookup Returning Values based on Date Range

    Sorry, you need to start your own thread... if you need to link to this one to show similarity, etc then that is fine...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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