Hello,

I am using structured table references to yield a desired value, as can be seen in Capture1 below:

Capture1.PNG

What I would like to do is copy an array of simple values such as the values seen below...

Capture2.PNG

...and paste them into the existing table (Table1). However, when I do this, the formula is automatically updated ("City" is changed to "Country").

Capture3.PNG

Is there a way to "fix" the header referenced in the formula such that the "City" value is still returned, despite the City header being moved from Column A to Column C?