Excel 2010 Mulitple Criteria IF AND formula ref. months and hour

[cajodonn]

I attached a sample spreadsheet for clarity purposes below. I want a formula to put in columns T- AC, that can look up what month it is and if it is a "1st" or "2nd" scenario, then perform a calculation depending on that criteria. The problem I am having is that I am not sure how to alter the formula so it will differentiate month to month. I included 2 July days and one August day for example purposes.

I want the formula for example in cell T6 to say:

IF the date cell (S5) is (for ex. July) AND the value in H6 is 0, THEN cell (T6) = 0. If not then compute ("Forecasted, System 1, July, 1st Scenario") Value - ("Actual, System 1, July, 1st Scenario" Value).

May sound complicated without seeing the table but the formula in there for the calculations is easy to follow, there are 5 reference tables in the Forecasted Data on the left, then the Actual Data For Each Day and Hour is in the middle columns, and the difference between them is computed in the right columns.

(Yes, in the forecasted columns "2nd" is listed before "1st" but thats how my data comes in so those columns are correct.

I think this should be a simple IF AND formula I jusat have had no success adjusting it so it can pull down and fillwhen the new months data comes in.

Thank you in advance for any help you can give me I really appreciate it!

[jeffr27]

Try this in T6: =IF(H6=0,0,INDEX($B$5:$C$16,MONTH(MAX($S$5:$S6)),MATCH(T$4,$B$4:$C$4,0))-H6)
You'll need to change the reference $B$5:$C$16 to $B$20:$C$31 for System 2, and so on for System 3, 4, 5, etc.

[cajodonn]

Jeff,

Formula worked great this is a major help. thank you very much for taking the time to help me with this issue.