+ Reply to Thread
Results 1 to 3 of 3

Match Closest Date in a table but the date can't be after the lookup value

  1. #1
    Registered User
    Join Date
    08-24-2019
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1

    Match Closest Date in a table but the date can't be after the lookup value

    2019-08-24_2-06-22.png

    Here is the formula I have, I can't figure out how to make it match the lookup date or less and not go over. Any help or guidance would be great.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,988

    Re: Match Closest Date in a table but the date can't be after the lookup value

    Pl upload sample file.


    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
    be sure to desensitize the data
    click “Go Advanced” (next to Post Quick Reply – bottom right),
    scroll down until you see “Manage Attachments”, click that,
    click “Browse”.
    select your file(s)
    click “Upload”
    click “Close window”
    click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,988

    Re: Match Closest Date in a table but the date can't be after the lookup value

    Try this.
    In E4 then copy down.
    Please Login or Register  to view this content.

+ 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. Lookup value based on closest date either side of a date
    By RollingStone88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2019, 08:38 AM
  2. Replies: 7
    Last Post: 04-03-2019, 05:00 PM
  3. Replies: 3
    Last Post: 08-23-2017, 07:04 PM
  4. [SOLVED] Match using today's date or next closest date
    By BobZZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2017, 12:13 AM
  5. Lookup Given Date in Cell A1 to date list in Cell E:E and find closest match
    By Branbran10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2015, 03:26 PM
  6. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  7. [SOLVED] Finding the closest Date - Lookup
    By dluhut in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-08-2013, 04:58 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