Display column name in reference

[lambchowder]

Hi, I'd like to know if there's a formula concatenation I could use that, when I reference one of a columns cells elsewhere on a sheet, will tell me the name of the column it came from if I assign that column a name. I don't know anything about VBA but if that's the only way I'll try to figure it out. Excel 2013

If a8 said 55 under a column called Qtr 4 then a reference to A8 would show 55 (Qtr4)

I could always simply use an absolute reference for the beginning of the column but if there's a faster way where I could do these on the fly I'd prefer that

 

[Robert Mika]

Hi, I'd like to know if there's a formula concatenation I could use that, when I reference one of a columns cells elsewhere on a sheet, will tell me the name of the column it came from if I assign that column a name. I don't know anything about VBA but if that's the only way I'll try to figure it out. Excel 2013

If a8 said 55 under a column called Qtr 4 then a reference to A8 would show 55 (Qtr4)

I could always simply use an absolute reference for the beginning of the column but if there's a faster way where I could do these on the fly I'd prefer that

Hello and welcome.
Is the whole column name "Q4"- Named Range or the heading?

 

[lambchowder]

I'd make the heading and name both (Q4)

 

[Robert Mika]

I'd make the heading and name both (Q4)

The easy way is to add two lookup formula.
Google for INDEX/MATCH example.