+ Reply to Thread
Results 1 to 8 of 8

Index Match with Date Value

  1. 11-16-2020, 06:43 AM #1
    UNNI NAIR
    UNNI NAIR is offline
    Registered User
    Join Date
    08-13-2014
    Location
    INDIA, PALGHAT
    MS-Off Ver
    Professional Plus 2019
    Posts
    61

    Index Match with Date Value

    Hi Friends

    I am facing a trouble in Index match with date value,
    here with enclose the sample file.

    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-16-2020, 06:48 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Index Match with Date Value

    You need to explain what you want. A non-working formula tells us nothing.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 11-17-2020, 01:22 AM #3
    UNNI NAIR
    UNNI NAIR is offline
    Registered User
    Join Date
    08-13-2014
    Location
    INDIA, PALGHAT
    MS-Off Ver
    Professional Plus 2019
    Posts
    61

    Re: Index Match with Date Value

    Glenn,

    I need a suitable formula in column K, specified Date in Column I,
    data pull from Range A2 to D133.
    Reply With QuoteRegister To Reply
  4. 11-17-2020, 03:28 AM #4
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Index Match with Date Value

    Maybe try at K2

    =IFERROR(INDEX(CuID,SMALL(IF($B$2:$B$133=I2,ROW($B$2:$B$133)-ROW($B$1)),COUNTIFS(I$2:I2,I2))),"")

    confirm by Ctrl+Shift+Enter
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  5. 11-17-2020, 03:57 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Index Match with Date Value

    Please confirm that you are still using Excel 2007.
    Reply With QuoteRegister To Reply
  6. 11-17-2020, 04:18 AM #6
    UNNI NAIR
    UNNI NAIR is offline
    Registered User
    Join Date
    08-13-2014
    Location
    INDIA, PALGHAT
    MS-Off Ver
    Professional Plus 2019
    Posts
    61

    Re: Index Match with Date Value

    Thanks Bo_Ry -
    this formula works Exactly.


    Thanks a lot
    Reply With QuoteRegister To Reply
  7. 11-17-2020, 04:19 AM #7
    UNNI NAIR
    UNNI NAIR is offline
    Registered User
    Join Date
    08-13-2014
    Location
    INDIA, PALGHAT
    MS-Off Ver
    Professional Plus 2019
    Posts
    61

    Re: Index Match with Date Value

    Yes .... Still using Excel 2007.
    Reply With QuoteRegister To Reply
  8. 11-17-2020, 04:23 AM #8
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Index Match with Date Value

    If interested, here is a non-array version that works with Excel 2007:

    =IFERROR(INDEX($D:$D,SMALL(INDEX(($B$2:$B$133<>I2)*10^10+ROW($B$2:$B$133),0),COUNTIFS(I$2:I2,I2))),"")
    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. [SOLVED] Index,Match,Match based on date Range - error in some cells
    By jmont in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-26-2019, 04:47 AM
  2. Index Match to find match date to a range of dates
    By downcrusher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 06:05 PM
  3. vlookup or index match with multiple conditions (Date closest match) in pivot table
    By dluhut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  4. [SOLVED] Index Match Based on One Date Criteria, Table Contains Beginning Date and End Date
    By jcox1953 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2014, 02:41 PM
  5. [SOLVED] INDEX date that MATCH on date range, MATCH code(string)
    By Dahlia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2014, 03:33 AM
  6. Index and Match with Two Criteria, and date Match Type is Less Than
    By ExcelQuestion in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-11-2013, 08:57 AM
  7. Date change & TBA when match cancelled. Try Match and index didn't work
    By micope21 in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 08:00 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