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.