INDIRECT syntax to get value from same cell, different wksht

[swtrader]

A11 = "ProjectedCash" (the name of a different worksheet than the active one - which is CashFlow)

CashFlow is the name of the worksheet where the following is in cell F17. This formula correctly pulls the value of F17 from ProjectedCash wksht.

=INDIRECT(""&$A$11&"!"&"F17")

However, I can't copy this formula to adjacent cells since the "F17" is constant. How can I change the syntax so that when the formula is copied to cell F18 of CashFlow, the formula changes to pull the value from F18 of ProjectedCash?

I've tried: =INDIRECT(""&$A$11&"!")&F17 . F17 changes to F18 when copied to the cell below. However, neither formula (in that syntax) pulls a value.

Thanks for your help.

swt

 

[swtrader]

10/17/2005 1:05:44 PM Re: Indirect reference to another sheet that can be dragged
Brian wrote...

....

From a post by Brian in 2005...

No matter what the cell, if you want cell ZZ## in the active worksheet

to equal the value in cell ZZ## in the worksheet nemed in cell A1 in

the active worksheet, try

=INDIRECT("'"&$A$1&"'!RC",0)

http://www.eggheadcafe.com/forumarchives/excelworksheetfunctions/oct2005/post24423660.asp

swtrader
-- If you don't know where you're going, you'll always know when you're not there.