+ Reply to Thread
Results 1 to 5 of 5

Why this match/Index formula works in Excel 2007 but not in Excel 2002??

  1. #1
    Forum Contributor
    Join Date
    11-07-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Why this match/Index formula works in Excel 2007 but not in Excel 2002??

    Hi all experts out there,

    May I know why my below formula work for Excel 2007 but not Excel 2002?

    =IFERROR(INDEX(PartNum!A1:C45000,MATCH(1,(PartNum!B:B=SR_From!H10)*(PartNum!C:C=SR_From!H11),0),1),"")

    As for Excel 2007, there is nothing display when nothing match. Whereas when open the Excel file in version 2002,
    it appears "#Name" error. May I know how can I rectify this issues?

    Thank you so much for all advise.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,249

    Re: Why this match/Index formula works in Excel 2007 but not in Excel 2002??

    Hi Evelyn,

    IfError wasn't available in 2002 Excel. It was new in 2007. Read this link to convert it back to 2002.

    http://www.professionalexcel.com/201...ith-ifiserror/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,649

    Re: Why this match/Index formula works in Excel 2007 but not in Excel 2002??

    Cross-posted at http://www.mrexcel.com/forum/excel-q...el-2002-a.html
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,991

    Re: Why this match/Index formula works in Excel 2007 but not in Excel 2002??

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    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

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,991

    Re: Why this match/Index formula works in Excel 2007 but not in Excel 2002??

    wow so many forum-induced double posts

+ 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] This formula works but I donīt understand why Index(Index) match
    By campelliann in forum Excel General
    Replies: 2
    Last Post: 01-25-2016, 05:55 PM
  2. [SOLVED] Excel 2007 : Removing the #n/a from this index match formula
    By Icehockey44 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2015, 12:47 PM
  3. Index, Match VBA Excel 2007
    By wid2001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 01:02 PM
  4. Excel 2007 : Index, Match, Large Formula: Multiple Criteria, Multiple Ranges
    By SimpleJack in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2013, 08:54 AM
  5. [SOLVED] Excel 2007 : Sumif, Index, match formula
    By Bebe22 in forum Excel General
    Replies: 4
    Last Post: 07-27-2012, 10:27 AM
  6. Replies: 4
    Last Post: 03-07-2012, 01:19 PM
  7. Replies: 2
    Last Post: 01-20-2005, 10:06 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