Formula in Name Manager

Just to clearify the problem here:
Putting the formula "=LEFT(ADDRESS(2,MATCH(INDIRECT("Sheet1!"&ADDRESS(3,COLUMN())),INDIRECT(INDIRECT("Sheet1!"&ADDRESS(2,COLUMN()))&"!$A$1:$F$1"),0)),2)" directly into a cell will work give the result "$B" in the cell.
Putting the exact same formula into the name manager with a given name, for instance the name GetColumn and then putting the formula "=GetColumn" into a cell will give an error.

It works with simple formulas, for instance I can make a formula in the name manager called SimpleFormula and set it to "=1+1" and in a cell I can put "=SimpleFormula" into and it will give the result 2. But not with the specific formula above, properly due to the dynamic colums and use of indirect.

I added a new file to try to illustrate the issue more clearly.

Any help would really be appreciated.