Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference a cell for a formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference a cell for a formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference a cell for a formula
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 "snax500" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference a cell for a formula
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") "Bernard Liengme" wrote: 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 "snax500" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |