Dynamic Indirect Function Help

[Jenkins87]

Hello,

I have this formula that works fine: =IFERROR((INDIRECT($A2&"!C30")),"")
I need the column in the "C30" reference to change as I copy and paste it to the left or the right (ie. B30, D30)
I'm guessing I need to use the "column" function in there but I can't figure it out.


Any help would be greatly appreciated!

Glenn

 

[shg]

=IFERROR(INDIRECT($A2 & "!" & CELL("address", C30)), "")

 

[Jenkins87]

Thanks a lot! Worked exactly how I needed I to. Chees!

 

[shg]

You're welcome.