Stop table backfilling lookups

------SOLVED------

So I have

Col A - name

Col B - lookup to pull location based on name

We have a rotating staff rota when every 2 months people do a rotation in a remote only team.

This table started in dec and there was a staffing shuffle in Feb to a new remote team but when I change the xlookup to pull the new areas the table automatically applies the formula to the entire column resulting in the location area being incorrect for dec and Jan. Can I stop this from happening?