+ Reply to Thread
Results 1 to 4 of 4

Lookup for a date between 2 other dates which matches the given criteria

  1. #1
    Registered User
    Join Date
    07-16-2017
    Location
    Dammam
    MS-Off Ver
    Office 365
    Posts
    10

    Lookup for a date between 2 other dates which matches the given criteria

    Good Day,

    What formula can I use to get the first result of a value which is more than a cell but less than another.
    On the attached file, I need the formula on Column C, that matches the same "Code" with date more than B but less than C.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Lookup for a date between 2 other dates which matches the given criteria

    I think you can do that with this formula in C2 (and copy down):
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Lookup for a date between 2 other dates which matches the given criteria

    Try this
    In C2, then drag down.
    Please Login or Register  to view this content.

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Lookup for a date between 2 other dates which matches the given criteria

    @hazeljohn19
    Thx for the rep. From the comment I assume that this solved your problem.
    If so pls mark the thread as SOLVED (see Thread Tools in the menu above).

+ 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] Multiple lookup criteria and sum values based on matches.
    By skonduru in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-31-2016, 11:53 PM
  2. Lookup X-th value that matches criteria
    By Ronnet2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2015, 01:17 PM
  3. [SOLVED] Sum if criteria matches and is between certain dates
    By Benjiboi_87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2015, 12:53 AM
  4. [SOLVED] Lookup with multiple criteria and matches
    By pmeans in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2013, 04:58 PM
  5. Lookup with multiple criteria and matches
    By cplian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2011, 01:52 AM
  6. [SOLVED] V-lookup and summing values if more than 1 matches criteria
    By holcay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2006, 11:55 AM
  7. Is it possible to do a vertical lookup that matches on 2 criteria
    By lshaw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-16-2005, 02:06 PM

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