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?

=INDIRECT("'Tracking Sheet'!a4")

So, quotes around the reference. If you omit the space in the sheet name, you don't need the apostrophes, which is easier

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Confused_Euffy" wrote in message
...
|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?

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

It worked a treat. Thank you for the quick response.

"Niek Otten" wrote:

=INDIRECT("'Tracking Sheet'!a4")

So, quotes around the reference. If you omit the space in the sheet name, you don't need the apostrophes, which is easier

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Confused_Euffy" wrote in message
...
|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?

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