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 #.
<TBODY>
</TBODY>
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 #.
Sheet 1 | |||||
Feb-13 | |||||
Actual | |||||
$ - | |||||
Sheet 2 | |||||
Jan-13 | Feb-13 | Mar-13 | Apr-13 | ||
Actual | Actual | Budget | Budget |
<TBODY>
</TBODY>