INDIRECT and SUBSTITUTION creating#REF Error

[knopp]

I have a column of sheet tab names in Column A. I would like Column B to reference cell G44 in each corresponding sheet tab. This is the code I am using. However, it is giving me a reference error. Does anyone have any idea what I am doing wrong?


=INDIRECT((SUBSTITUTE(TRIM(A6)," ","_"))&"!G44")

Edit: The title should say SUBSTITUTE

 

[Fluff]

If the sheet names in col A are correct, just use

=INDIRECT(A6&"!G44")

 

[GWteB]

And in case your sheet names contain spaces, try it like this ...

=INDIRECT("'"&A6&"'!G44")

 

[knopp]

And in case your sheet names contain spaces, try it like this ...

=INDIRECT("'"&A6&"'!G44")

Thank you! This works perfectly!

 

[knopp]

If the sheet names in col A are correct, just use

=INDIRECT(A6&"!G44")

Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.