Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula Reference Point
I sure have had good luck in the past with people helping me out with
formulas on this board, hope my luck holds out this time as well. I have a situation where my formula would be identical across many cells, except for a unique reference point number listed in each formula. Is there a way to change my formula to be generic and reference a stand-alone cell instead of having the unique reference point number being imbedded in each formula? For example in the formula listed below, I need the formula to be modified to reference the 00036 in a stand-alone cell. Any ideas? Thanks Scott D. ='P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$31-'P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$30 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula Reference Point
Say the stand-alone cell containing 00036 is A1, then try this:
=INDIRECT("'P:\PSReport\GLReport\STRPL\PAGE1\2006\ 6\["&A1&".xls]Sheet1'!$U$31")-INDIRECT("'P:\PSReport\GLReport\STRPL\PAGE1\2006\6 \["&A1&".xls]Sheet1'!$U$30") Regards, Stefi €˛Scott D.€¯ ezt Ć*rta: I sure have had good luck in the past with people helping me out with formulas on this board, hope my luck holds out this time as well. I have a situation where my formula would be identical across many cells, except for a unique reference point number listed in each formula. Is there a way to change my formula to be generic and reference a stand-alone cell instead of having the unique reference point number being imbedded in each formula? For example in the formula listed below, I need the formula to be modified to reference the 00036 in a stand-alone cell. Any ideas? Thanks Scott D. ='P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$31-'P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$30 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula Reference Point
Stefi,
Thank you so much for taking the time to help me with this problem. Your solution is going to save me a great deal of time and effort. I really appreciate the fact that you took the time to actually write out the solution for me rather than just telling me to use the INDIRECT function. I wish there was some way I could repay you for sharing your expertise with me. Scott D. "Stefi" wrote: Say the stand-alone cell containing 00036 is A1, then try this: =INDIRECT("'P:\PSReport\GLReport\STRPL\PAGE1\2006\ 6\["&A1&".xls]Sheet1'!$U$31")-INDIRECT("'P:\PSReport\GLReport\STRPL\PAGE1\2006\6 \["&A1&".xls]Sheet1'!$U$30") Regards, Stefi €˛Scott D.€¯ ezt Ć*rta: I sure have had good luck in the past with people helping me out with formulas on this board, hope my luck holds out this time as well. I have a situation where my formula would be identical across many cells, except for a unique reference point number listed in each formula. Is there a way to change my formula to be generic and reference a stand-alone cell instead of having the unique reference point number being imbedded in each formula? For example in the formula listed below, I need the formula to be modified to reference the 00036 in a stand-alone cell. Any ideas? Thanks Scott D. ='P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$31-'P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$30 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Cell reference in different worksheet in formula | Excel Worksheet Functions | |||
Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |