+ Reply to Thread
Results 1 to 3 of 3

INDIRECT Formula used to work but now it isn't..

  1. #1
    Registered User
    Join Date
    11-22-2019
    Location
    Sydney
    MS-Off Ver
    365 for Business
    Posts
    2

    INDIRECT Formula used to work but now it isn't..

    Hello,

    I have a formula that used to work. It would work out the date of a task whether or not it has a dependency on another task or not and act accordingly with INDIRECT. It is below:

    =IF($J12="Yes",IF(INDIRECT("O"&I12+9)="","",IF(I12<>"",WORKDAY(INDIRECT("O"&I12+9),1),K12)),IF(INDIRECT("N"&I12+9)="","",IF(I12<>"",WORKDAY(INDIRECT("N"&I12+9),1),K12)))

    The problem is that when I12 returns "", M12 (which has this formula) still won't return the date from K12.

    This has me scratching my head hard as it was working before and now it is not. Any help would be great, thanks!

    Link to the file:
    Attached Files Attached Files

  2. #2
    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,917

    Re: INDIRECT Formula used to work but now it isn't..

    If you look at this part of the formula...
    ...INDIRECT("N"&I11+9)...
    If I11 is empty, the INDIRECT (always) returns a reference to N9. Because you have merged N8 and N9, N9 will always be empty, so the reference will always be to an empty cell.
    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

  3. #3
    Registered User
    Join Date
    11-22-2019
    Location
    Sydney
    MS-Off Ver
    365 for Business
    Posts
    2

    Re: INDIRECT Formula used to work but now it isn't..

    I knew it was something as simple as this, thank you!!

+ 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. Indirect function causing formula not to work
    By JohnDoh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2015, 11:48 AM
  2. Replies: 6
    Last Post: 10-22-2014, 09:07 AM
  3. [SOLVED] ERROR ALERT on INDIRECT formula won't work
    By vio.coman in forum Excel General
    Replies: 2
    Last Post: 10-08-2014, 06:12 AM
  4. ERROR ALERT on INDIRECT formula won't work
    By vio.coman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2014, 05:16 AM
  5. [SOLVED] Indirect formula doesn't work
    By Ztv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2014, 05:15 PM
  6. [SOLVED] Will an INDIRECT formula combined with a VLOOKUP work?
    By DRFJR in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2014, 09:03 AM
  7. Replies: 1
    Last Post: 02-28-2012, 02:55 AM

Tags for this Thread

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