+ Reply to Thread
Results 1 to 3 of 3

If Iferror Index Match

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    California
    MS-Off Ver
    2016
    Posts
    11

    If Iferror Index Match

    Is the title remotely possible to accomplish?

    I'll begin where I reside currently... my formula below is my current iferror,index,match array that is working as intended.
    =IFERROR(INDEX(ZRSCH!Y:Y,MATCH(1,(A2=ZRSCH!C:C)*(B2=ZRSCH!D:D),0)),"Keep Current Date")

    The above is currently returning a date where applicable and where a date is not, it will say Keep Current Date.
    I need to add a criteria requirement for the Date that is being returned, criteria being two dates I have already provided elsewhere of a window of 7 workdays, forward and backwards. So for the example: C1 = 03/08/2019 and D1 = 03/28/2019 if we ran this today.

    My initial thought is another column, but I would truly like to avoid this. Basically, if the return falls between C1 and D1 OR it cannot be indexed, I want it to "Keep Current Date", Otherwise, it is to return the date it found.
    Last edited by JKNACKSTEDT; 03-20-2019 at 01:02 PM.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: If Iferror Index Match

    If I've understood... you could add the tests to your MATCH

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

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

    NOTE: in both cases I'd advise against using entire column references in the above -- you might be better off creating a Dynamic Named Range so as to limit the scope of the calc.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: If Iferror Index Match

    It might also be better to add a helper column, and base the match on that?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Having more than one 'match' in an iferror-index-match formula
    By Sedgeway in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2018, 10:38 PM
  2. Iferror + If + Index + Match in VBA
    By Andre2016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2017, 06:58 AM
  3. IFERROR INDEX MATCH Im stuck
    By JB20 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2017, 09:57 AM
  4. [SOLVED] IFERROR and IFBLANK within INDEX and MATCH
    By russwongg in forum Excel General
    Replies: 2
    Last Post: 08-21-2015, 11:52 AM
  5. [SOLVED] Sum used with index match and iferror
    By tlstevens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2015, 02:43 PM
  6. [SOLVED] Iferror, index & match
    By meh999 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-26-2014, 08:43 AM
  7. Adding IFERROR to INDEX MATCH
    By brad999 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2013, 04:18 AM

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