Need help with IF statement looking at ranges containing text.
In summary form - we have a workbook with sheets represented below. Each month we want the highlighted cell to change to the # in sheet 2 where the month matches on both sheets AND sheet 2 reflects "ACTUAL" for that matching month. So when we are reporting Feb. actuals we will change "Budget" to "Actual" on sheet 2 under Feb., and sheet one will pull that number, replacing the Jan. actual #.
[TABLE="width: 288"]
<TBODY>[TR]
[TD="class: xl63, width: 192, bgcolor: transparent, colspan: 3"]Sheet 1
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]Feb-13
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]Actual
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: yellow"]$ -
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, colspan: 6"]Sheet 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]Jan-13
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]Feb-13
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]Mar-13
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]Apr-13
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl70, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl70, bgcolor: transparent"]Budget
[/TD]
[TD="class: xl73, bgcolor: transparent"]Budget
[/TD]
[/TR]
</TBODY>[/TABLE]
In summary form - we have a workbook with sheets represented below. Each month we want the highlighted cell to change to the # in sheet 2 where the month matches on both sheets AND sheet 2 reflects "ACTUAL" for that matching month. So when we are reporting Feb. actuals we will change "Budget" to "Actual" on sheet 2 under Feb., and sheet one will pull that number, replacing the Jan. actual #.
[TABLE="width: 288"]
<TBODY>[TR]
[TD="class: xl63, width: 192, bgcolor: transparent, colspan: 3"]Sheet 1
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]Feb-13
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]Actual
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: yellow"]$ -
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, colspan: 6"]Sheet 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]Jan-13
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]Feb-13
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]Mar-13
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]Apr-13
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl70, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl70, bgcolor: transparent"]Budget
[/TD]
[TD="class: xl73, bgcolor: transparent"]Budget
[/TD]
[/TR]
</TBODY>[/TABLE]