+ Reply to Thread
Results 1 to 6 of 6

Formula result will not show when formula is copied to another cell

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    5

    Formula result will not show when formula is copied to another cell

    I had created this formula that worked fine:
    =INDEX('COGS sorted '!$F$9:$F$249,MATCH(A47,IF('COGS sorted '!$B$9:$B$249=C47,'COGS sorted '!$A$9:$A$249),0))

    I then added an ISNA formula to the above formula in cell L43 and the result is blank but should be 529.39. This is the formula:
    IF(ISNA(INDEX('COGS sorted '!$F$10:$F$250,MATCH(A43,IF('COGS sorted '!$B$10:$B$250=C43,'COGS sorted '!$A$10:$A$250),0))),"",INDEX('COGS sorted '!$F$10:$F$250,MATCH(A43,IF('COGS sorted '!$B$10:$B$250=C43,'COGS sorted '!$A$10:$A$250),0)))

    I know that Excel won't display a result if the formula contains over 255 characers, but my formula has only 236. Anybody know why the result is not being displayed?

    Thanks!
    Attached Files Attached Files
    Last edited by nabraham00; 07-06-2012 at 09:57 AM.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,452

    Re: Formula result will not show when formula is copied to another cell

    Welcome to the forum. You have to enter that formula with Ctrl+Shift+Enter. When you do that you get 529.39

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,452

    Re: Formula result will not show when formula is copied to another cell

    BTW - if you don't need this file to work in older Excel versions you can use:

    =IFERROR(INDEX('COGS sorted '!$F$10:$F$250,MATCH(A43,IF('COGS sorted '!$B$10:$B$250=C43,'COGS sorted '!$A$10:$A$250),0)),"")

    also needs to be confirmed with C-S-E

  4. #4
    Registered User
    Join Date
    07-05-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula result will not show when formula is copied to another cell

    Thanks, I can't believe I forgot that!

  5. #5
    Registered User
    Join Date
    07-05-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula result will not show when formula is copied to another cell

    This will shorten the formula. Thanks!

  6. #6
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,452

    Re: Formula result will not show when formula is copied to another cell

    You're welcome. Thanks for the 'star tap'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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