indirect formula

[Confused_Euffy]

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?

 

[Niek Otten]

=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

|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]

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]

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

 

[Confused_Euffy]

Ah i see now, thank you.

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.