ChrisJ
10-26-2009, 05:49 AM
Hi,
I am trying to remember how to do something that Im sure I used to do many years ago...
I am trying to have a formula be dependant on the text in another cell for example
Cell a1 = Redruth
Cell a2 = =+'C:\11.MPE Data\Sept\[MPE FY09 - "VALUE of A1" Sept.xls]Local Currency'!$B$8
Value of a2 should be =+'C:\11.MPE Data\Sept\[MPE FY09 - Redruth Sept.xls]Local Currency'!$B$8
I can't seem to be able to correctly reference A1 in the formula ..
Many thanks in advances
I am trying to remember how to do something that Im sure I used to do many years ago...
I am trying to have a formula be dependant on the text in another cell for example
Cell a1 = Redruth
Cell a2 = =+'C:\11.MPE Data\Sept\[MPE FY09 - "VALUE of A1" Sept.xls]Local Currency'!$B$8
Value of a2 should be =+'C:\11.MPE Data\Sept\[MPE FY09 - Redruth Sept.xls]Local Currency'!$B$8
I can't seem to be able to correctly reference A1 in the formula ..
Many thanks in advances