Having trouble with this one. These are the rules I want to include in that formula above:Please Login or Register to view this content.
* If there is a date in column: ((TEXT('Overview - 2013'!$D$15:$D$5000,"mmmm")=B3) then use THIS date range that is eqal to "B3" in the formula above. If there is NOT a date in there, then use: ((TEXT('Overview - 2013'!$M$15:$M$5000,"mmmm")=B3)
So basically, column D takes precedence over Column M... Not sure how to include that rule?
Bookmarks