It seems to me that it is not possible for a 'table' (meaning excel's table tool) column heading to be equal to a named range. Take the below example. My table is in cells B3:D6 (i.e. I put that data in those cells, then went Insert > Table > 'My table has headings'.
In cell F4 I have a named range 'name_person', who's value is 'Person'.
If I now try to set cell B3 as '=name_person', it just returns '0'. Does anyone know if it is possible to set the table column name to a named range?