Display Column Name In Reference?

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