+ Reply to Thread
Results 1 to 10 of 10

Index Match using text strings and dates

  1. 10-30-2015, 01:34 PM #1
    ConcreteGuy79
    ConcreteGuy79 is offline
    Registered User
    Join Date
    10-28-2015
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2010
    Posts
    5

    Index Match using text strings and dates

    I need help! I've made numerous attempts with no luck. I need M2 to retrieve the text string with latest date. Please help.
    I have attached a sample workbook.

    Thank you

    Sample Workbook.xlsx
    Sample Workbook 2.xlsx
    Last edited by ConcreteGuy79; 10-30-2015 at 02:51 PM. Reason: Added Sample Workbook 2
    Reply With QuoteRegister To Reply
  2. 10-30-2015, 01:43 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Index Match using text strings and dates

    Enter this array formula in M2

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    ***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
    Last edited by AlKey; 10-30-2015 at 01:45 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 10-30-2015, 01:48 PM #3
    ConcreteGuy79
    ConcreteGuy79 is offline
    Registered User
    Join Date
    10-28-2015
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2010
    Posts
    5

    Re: Index Match using text strings and dates

    This just displays the date. I really need it to display the original text string.
    Thanks
    Reply With QuoteRegister To Reply
  4. 10-30-2015, 01:50 PM #4
    mcmahobt
    mcmahobt is offline
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Index Match using text strings and dates

    Another way, also entered as an array formula. This assumes your dates will always be in the mm/dd/yyyy format:

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."
    Reply With QuoteRegister To Reply
  5. 10-30-2015, 01:53 PM #5
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Index Match using text strings and dates

    Ok Here is with text

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    ***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
    Reply With QuoteRegister To Reply
  6. 10-30-2015, 02:02 PM #6
    ConcreteGuy79
    ConcreteGuy79 is offline
    Registered User
    Join Date
    10-28-2015
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2010
    Posts
    5

    Re: Index Match using text strings and dates

    Is this possible without the array formula?
    Reply With QuoteRegister To Reply
  7. 10-30-2015, 02:02 PM #7
    José Augusto
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Index Match using text strings and dates

    Hi

    i use this array formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 10-30-2015, 02:18 PM #8
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Index Match using text strings and dates

    Although this is an array formula it doesn't require use for CTRL+SHIFT+ENTER

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 10-30-2015, 02:30 PM #9
    ConcreteGuy79
    ConcreteGuy79 is offline
    Registered User
    Join Date
    10-28-2015
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2010
    Posts
    5

    Re: Index Match using text strings and dates

    I think we are closer. Although this does what I need it too I can't get it to work on columns N through Z. I am not sure how this formula works but Columns N through Z are also Different tasks that are labeled on row 1 and when I copy the formula it just shows the Set Forms String.
    Reply With QuoteRegister To Reply
  10. 10-30-2015, 02:54 PM #10
    ConcreteGuy79
    ConcreteGuy79 is offline
    Registered User
    Join Date
    10-28-2015
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2010
    Posts
    5

    Re: Index Match using text strings and dates

    I think I made this more confusing by not posting the actual workbook. I have attached sample workbook 2 for your review. I enter in the data in range O2:AX2 through a user form that I created. I need the range BG2:BS2 to retrieve the information related to the column heading with the latest date. I appreciate your time and I apologize if I made this more confusing.

    Thank you
    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. Formula to Verify/Match Strings of text
    By jav171 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2015, 01:56 PM
  2. [SOLVED] INDEX MATCH based on part of strings
    By Dahlia in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-07-2014, 07:55 AM
  3. Multiple Criteria Index/Match Function in VBA Looking Up Dates/Strings/Numbers
    By nadstradamus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 12:35 PM
  4. [SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings
    By bkwins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  5. Match Similar (But Not Exact) Text Strings
    By jamesjhhill in forum Excel General
    Replies: 1
    Last Post: 11-12-2012, 12:50 PM
  6. Match two text Strings
    By swampedindata in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-15-2012, 12:32 PM
  7. VLOOKUP to match numbers to strings of text
    By rtabaldi in forum Excel General
    Replies: 3
    Last Post: 07-18-2011, 09:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1