I am tying to use Indirect to build a dynamic statement. I keep getting the #REF error and I haven't been able to figure out how to do it correctly.
I have the pieces of the reference in different cells.
A1 = MW
A3 = 01
and the cell on the tab I want to reference is L27 (just for kicks it equals 3,003)
I am constructing the Indirect statement as such:
Formula:
=INDIRECT(" ' " & A1 & CHAR(32) & A3 & " '!" & L27)
and I need it to return this:
Formula:
='MW 01'!$L$27
Any help would be greatly appreciated. Thank you!!
Bookmarks