Hi,
I need to be able to change the sheet referencing information in a formula according to what is in the cell next to it.
Eg.
Cell A1
2011
Cell A2
=IF(ISBLANK('R:\FRED\[BOB.xls]2011'!B4)=TRUE,"",'R:\FRED\[BOB.xls]2011'!B4)
The 2 locations of 2011 in A2 need to change with the contents of A1. For example if I want I change A1 to say 2012, then A2 would change automatically to
=IF(ISBLANK('R:\FRED\[BOB.xls]2012'!B4)=TRUE,"",'R:\FRED\[BOB.xls]2012'!B4)
Thank you very much.
Bookmarks