Forum Discussion

PanBrodacz's avatar
PanBrodacz
New Member
3 years ago

Renaming columns in data source causing #REF! error in formulas with structured reference

1. I have a table with data from other file and formulas with structured reference to that table.   2. When I rename column in file with data source it causing #REF! error in formula with str...
Need Help
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
3 years ago

Hi PanBrodacz ,

 

Here is a bit old fashion method:

 

  1. Cell E1, reference to Cell A1;
  2. Cell E2 add formula: Indirect("List1["&E1&"]")

Regards

KT