indirect formula
Ah i see now, thank you.
"Dave Peterson" wrote:
You always want to point at A4 of "Tracking Sheet"?
If yes, try:
=INDIRECT("'Tracking Sheet'!A4")
When you used:
=INDIRECT('Tracking Sheet'!A4)
excel was looking for something that looked like an address in A4 of that
tracking sheet. And then tried to go get the value in the cell that 'Tracking
Sheet'!A4 pointed to.
Confused_Euffy wrote:
I am trying to use the indirect formula to look at a particular cell on
another worksheet. My formula is - =INDIRECT('Tracking Sheet'!A4). The
result i am getting is #REF. I am inserting new rows in the tracking sheet
but i would like A4 to be the constant.
Hope this makes sense. Can somebody help me please?
--
Dave Peterson
|