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
Bookmarks