Results 1 to 2 of 2

Index Match using Min to find a text value based on the closest date to today

Threaded View

  1. 01-04-2018, 09:23 PM #1
    Ericpinkel
    Ericpinkel is offline
    Registered User
    Join Date
    01-04-2018
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    1

    Smile Index Match using Min to find a text value based on the closest date to today

    I am trying to use a simple index match with the min function to find a text value based on the date closest to today.

    After many tries I am still getting the #N/AA result. If anyone can help me it would be a huge help.

    The formula that I am using in C:8
    Formula: copy to clipboard 
    =INDEX(B2:B8,MATCH(MIN(IF(A2:A8>=TODAY(),A2:A8)), 1))


    I was able to get it to work with Vlookup, but I need to add additional criteria for the match.

    This is the Vlookup Formula that is working in C:7
    Formula: copy to clipboard 
    =VLOOKUP(MIN(IF(A2:A8>=TODAY(),A2:A8)),$A$2:$B$8,2,0)


    Index-match-min_01.jpg
    Attached Files Attached Files
    Last edited by Ericpinkel; 01-04-2018 at 09:31 PM.
    Reply With QuoteRegister To Reply
« 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. VBA to loop through range to find date closest to today's date
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2017, 02:08 AM
  2. [SOLVED] Need to find a text string that starts with (x) that is closest to my initial index match
    By LeeXCEL in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 08-15-2017, 06:09 PM
  3. [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
  4. [SOLVED] Help with INDEX MATCH to find absolute closest value
    By mave27 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-24-2015, 04:24 AM
  5. [SOLVED] Find closest date to today in a row of dates
    By scottmcclean in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2014, 04:29 PM
  6. [SOLVED] Formula to find date closest to today
    By mattress58 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-09-2014, 12:18 PM
  7. [SOLVED] Find Entry With Closest Date and Time to Today
    By Steve N. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2012, 06:09 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1