Help with INDIRECT function

[BKGLTS]

Hello,

I have this formula, which works great for copying up or down, but doesn't work when copying left or right.

=INDIRECT("'WBS"&ROW($A24)-(ROW($A24)-COUNTA($A$18:$A24))&"'!"&"E$12")

The issue I believe is the last "E$12".
It is in parentheses, which is fine for filling up or down, but when I fill to the left or right I need the Column to change.
So when I copy this formula into the next cell to the right E$12 should change to F$12.
I have tried removing the parentheses , but it doesn't like it when I do that, because it try's to place the value of that cell into the address, which is incorrect.

I cannot figure out how to make this work.
Please help.

Thank you,
B

 

[Scott T]

By putting it in quotes you have turned it into text. Since it is text and not a cell reference it will not update when copied. Instead of "E$12" use E$12

 

[BKGLTS]

Scott,

I have tried removing the quotes , but it doesn't like it when I do that, because it try's to place the value of that cell into the address, which is incorrect.
The current result of this INDIRECT formula is: 'WBS3'!E$12
If I simply remove the quotes around E$12 the result will be:

'WBS3'!0 , which results in a #REF error, because it tries to place the value of cell E$12 into the address I am trying to create with the INDIRECT function.​

_{^{<strike>
</strike>}}​

 

[BKGLTS]

I think I figured it out.
=INDIRECT("'WBS"&ROW($A24)-(ROW($A24)-COUNTA($A$18:$A24))&"'!"&SUBSTITUTE(ADDRESS(1,CELL("col",AB24),4),"1","")&"$12")

 

[Scott T]

never mind.