indirect formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

|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.
 
Ah i see now, thank you.

Dave Peterson said:
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.
Click to expand...
 
Back
Top