F
Frick
Formula
{=(INDEX(Production_Sch!$D$38:$IH$38,MATCH(YEAR(WRKSHT_Mthly!AB$3),YEAR(Prod
uction_Sch!$D$4:$IH$4),0)))}
I have this formula that I entered using CTRL-SHIFT-ENTER.
The formula should return the result in Row 38 matching the month range
D4:IH4 in that sheet with the month in AB3
AB3 = Start of the Month = 12/1/06
D4:IH4 = End of Months from 1/31/04 through 12/31/2020
The formula is returning a value of 0, when it should be returning a value
of 1. What's starnge is that in the next col, the same formula (except AB3
is now AC3) is returning the correct value of 1.
I have checked and rechecked that the references are correct and that the
month is correct and the value is in fact 1. The formula works correctly
everywhere else except for any date earlier then 1/1/07.
Thanks for the help.
{=(INDEX(Production_Sch!$D$38:$IH$38,MATCH(YEAR(WRKSHT_Mthly!AB$3),YEAR(Prod
uction_Sch!$D$4:$IH$4),0)))}
I have this formula that I entered using CTRL-SHIFT-ENTER.
The formula should return the result in Row 38 matching the month range
D4:IH4 in that sheet with the month in AB3
AB3 = Start of the Month = 12/1/06
D4:IH4 = End of Months from 1/31/04 through 12/31/2020
The formula is returning a value of 0, when it should be returning a value
of 1. What's starnge is that in the next col, the same formula (except AB3
is now AC3) is returning the correct value of 1.
I have checked and rechecked that the references are correct and that the
month is correct and the value is in fact 1. The formula works correctly
everywhere else except for any date earlier then 1/1/07.
Thanks for the help.