+ Reply to Thread
Results 1 to 4 of 4

Formula corrupted

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    King of Prussia, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula corrupted

    Hello I am in dire need of some assistance with some Excel 2010 formulas.

    I was assigned the task of maintaining a workbook, at my place of employment. The workbook has three worksheets and one of the worksheets has incorrect formulas, that no one knows how to fix and the originator is no longer with the company.

    The first tab is called the Master tab, it is a detailed template that details milestone dates for projects. The second tab is called the Nightly Pull which is basically a feeder tab, (A report is pulled daily illustrating the plan, forecast, and actualized dated for projects. The daily report is then copied and pasted into the NightlyPull tab.) Once the NightlyPull tab is updated the dates feed into the Master tab. The last tab is called the Loader. The Loader tab is used to upload any forecast-ed dates into the database and is the tab where my issues come in at.

    The formulas between the Master tab and the Loader tab are not working correctly. When a date has been reforested on the Master tab, it is supposed to show in the Loader tab so it can be uploaded into the database, it should also be conditionally formatted to show that there is a change to the Master tab in the loader tab.

    Here is the first formula I am dealing with:
    =IF(F$1="Yes",IF(INDEX(MASTER!$1:$1048576,MATCH($C5,MASTER!$A:$A,0),MATCH(G$2,MASTER!$5:$5,0))="",IF(INDEX(MASTER!$1:$1048576,MATCH($C5,MASTER!$A:$A,0),MATCH(F$2,MASTER!$5:$5,0))="","",INDEX(MASTER!$1:$1048576,MATCH($C5,MASTER!$A:$A,0),MATCH(F$2,MASTER!$5:$5,0))),""),"")

    & here is the second one:
    =IF(G$1="Yes",IF(INDEX(MASTER!$1:$1048576,MATCH($C5,MASTER!$A:$A,0),MATCH(G$2,MASTER!$5:$5,0))<>"",INDEX(MASTER!$1:$1048576,MATCH($C5,MASTER!$A:$A,0),MATCH(G$2,MASTER!$5:$5,0)),""),"")

    Can anyone help me figure this issue out?

    Thank you kindly.
    ~KOP

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Formula corrupted

    Hi
    without seeing the data, it's not obvious. Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    10-02-2013
    Location
    King of Prussia, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula corrupted

    Hello and thank you for assisting me.

    I have attached a mock up file as you requested.

    Please review and advise.

    Thanks again.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-02-2013
    Location
    King of Prussia, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula corrupted

    Also, in addition to what I am trying to do.

    The formulas in the third tab, which is the loader tab, should be feeding from the data in the first tab, which is the master tab.

    The data in the Master tab, feeds from the second tab, which is a daily report.

    I am suppose to be able to edit the dates in the master tab to be able to forecast as needed and the forecasted dates should be appearing in the third tab (loader tab) in a conditional format so that I will be able to recognize the data that is being edited from the data that is not being edited on the Master tab.

    But of course the formulas that are currently in the loader tab are not pulling in the correct data, or are just not working at all to provide me with a correct file to upload into my database.

    Thanks again for your help.

+ 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. is this file corrupted?
    By foxguy in forum Excel General
    Replies: 11
    Last Post: 09-29-2011, 06:43 AM
  2. Fix corrupted file
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2010, 06:21 PM
  3. CDO :-Attachments got corrupted
    By dollar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2009, 05:58 AM
  4. Corrupted Excel
    By erj22 in forum Excel General
    Replies: 0
    Last Post: 04-05-2005, 02:49 AM
  5. Corrupted Macro
    By VJ7777 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-03-2005, 01:06 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