Reference a cell for a formula

[snax500]

Is there a way to have a formula that references a cell as part of the
formula. For example, I have the following formula in many cells...

'G:\B\BUDGET\2008 Variance\Jul08\[Jul Variances.xls]010 New York'!
$L32/1000. Is there a way to have the word "Jul" in a cell (A2) and
have +A2 as part of the formula. This is so that each month, I just
change A2 to the next month and all of my formulas change easily.

Thanks

 

[FSt1]

hi
you could use a concatinator. at the end of you formula add this...

&A2

if you want a space between the number and july add this...
& " " & A2

or an edited verson of your formula.....

'G:\B\BUD\\J\[Jul V.xls]010 New York'! $L32/1000 & " " & A2

regards
FSt1

 

[Bernard Liengme]

Not clear which 'Jul' or both. These should give you an idea

=INDIRECT("'G:\B\BUDGET\2008 Variance\Jul08\[" & A2 & "Variances.xls]010 New
York'!$L32/1000")

=INDIRECT("'G:\B\BUDGET\2008 Variance\" " A2 &"08\[" & A2 &
"Variances.xls]010 New York'!$L32/1000")

That is =INDIRECT( doublke-quote single-quote .....
best wishes

 

[Sheeloo]

I think Bernard entered a " instead of an &...
also a space before Variances.xls

Second formula should be
=INDIRECT("'G:\B\BUDGET\2008 Variance\" & A2 &"08\[" & A2 &
" Variances.xls]010 New York'!$L32/1000")

Not clear which 'Jul' or both. These should give you an idea

=INDIRECT("'G:\B\BUDGET\2008 Variance\Jul08\[" & A2 & "Variances.xls]010 New
York'!$L32/1000")

=INDIRECT("'G:\B\BUDGET\2008 Variance\" " A2 &"08\[" & A2 &
"Variances.xls]010 New York'!$L32/1000")

That is =INDIRECT( doublke-quote single-quote .....
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Is there a way to have a formula that references a cell as part of the
formula. For example, I have the following formula in many cells...

'G:\B\BUDGET\2008 Variance\Jul08\[Jul Variances.xls]010 New York'!
$L32/1000. Is there a way to have the word "Jul" in a cell (A2) and
have +A2 as part of the formula. This is so that each month, I just
change A2 to the next month and all of my formulas change easily.

Thanks