TABLE: Do not change colomn name in formulas when pasting

Hi all,

I use Index Match lookups / countifs in a table.

Once a week I paste new data into the sheet. With this paste I want to paste the headers as well, because the order is not always the same.

But, now when I do this the name of the column in the formula changes.

So for example:

Column A = Date
Column B = Description

Now someone else make the update and has

Column A = Description
Column B = Date

The goal with IndexMatch is that it will search in the name of the header.. But my formulas automatic change because the columnnames changed.
Is there a way to avoid this?

Thank you for replying!

Sorry I didn't attach te first time.

So I want to copy the data from sheet 'new data' into the table (but AFTER colomn D) on sheet 'export'.

The formula in column B refers to 'date requested' (which is now in column F) but this name changes when a different column name
is giving to column F.



Try pasting the new data into cel E2 and see what happens to the green cell formula, please.

I misposted the question, Started the good question in the right subject. This can be closed