+ Reply to Thread
Results 1 to 5 of 5

Lookup between two dates

  1. 11-29-2013, 02:13 PM #1
    cpmsimoes
    cpmsimoes is offline
    Registered User
    Join Date
    06-30-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    39

    Lookup between two dates

    Hello,

    Need your help! I'm stuck!

    Is there any way to return a string looked between two dates?

    I attach one Excel file with the resut I pretend.

    Thanks for your help.

    Regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-29-2013, 03:01 PM #2
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Lookup between two dates

    Hi,

    there are for sure better solutions


    Please Login or Register  to view this content.

    Regards
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 11-30-2013, 12:19 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Lookup between two dates

    Try this.....

    The formula given below is an array formula, so it needs to be confirmed with Ctrl+Shift+Enter and then copy down

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 11-30-2013, 01:51 AM #4
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Lookup between two dates

    =vlookup(g2,$a$2:$c$4;3,true)
    Reply With QuoteRegister To Reply
  5. 12-01-2013, 12:39 PM #5
    cpmsimoes
    cpmsimoes is offline
    Registered User
    Join Date
    06-30-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Lookup between two dates

    Thank you all!

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to lookup a set of dates within a column (filled w/dates) & output values accordingl
    By hcsf_25 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-21-2013, 07:55 PM
  2. [SOLVED] Multiple lookup with with variable dates, convert to fixed series of dates
    By gren in forum Excel General
    Replies: 1
    Last Post: 06-25-2012, 12:45 AM
  3. lookup dates
    By PhilH1982 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2007, 11:13 AM
  4. Lookup ID and between dates?
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2007, 04:29 AM
  5. Multiple lookup and Dates
    By Robo in forum Excel General
    Replies: 16
    Last Post: 01-09-2007, 07:22 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1