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

"snax500" wrote:

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